Tag: currency rates DAX

Currency Rates In Power BI: Handling Missing Data

Hierarchies In Power BI Visualizations

In this tutorial, you’ll learn how to handle missing data in a currency-rates table using DAX and power query. You’ll learn the different ways to manage the missing rates in your table and present them effectively in a dashboard in Power BI. You can watch the full video of this tutorial at the bottom of

Continue reading

Currency Rates Table – Accounting For Missing Data With DAX

Accounting For Missing Data In Currency Table with PowerQuery in Power BI and DAX

I’m going to show you how to deal with a currency rates table where some days are not accounted for. These days could be weekends or holidays. This may not be a problem sometimes, especially if the business you’re preparing a report for does not open on weekends and holidays. But if they do, you

Continue reading