Tag: currencies in Power BI

Solving Missing Currency Rates With Power Query In Power BI

In this tutorial, you’ll learn how to use Power Query for currency conversions in Power BI. You may watch the full video of this tutorial at the bottom of this blog. The method discussed in this blog will help you solve problems in your currency rates table using the last available rate. You’ll understand how

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