Tag: currencies in Power BI

Solving Missing Currency Rates With Power Query In Power BI

By Nick Mone, Enterprise DNA Expert on November 26, 2020October 26, 2022

In this tutorial, you’ll learn how to use Power Query for currency conversions in Power BI. You can 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

Posted in: currencies in Power BI, Currency Conversion, Power BI Currency, Power BI Currency Conversion, Power BI DAX, Power BI Power Query, power pivot power bi, Power Query, Query Editor

Business Intelligence

Currency Rates Table – Accounting For Missing Data With DAX

By Nick Mone, Enterprise DNA Expert on October 20, 2020October 27, 2022

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

Posted in: Advanced DAX Exchange Rates, currencies in Power BI, currency rates DAX, currency table data, exchange rates, power bi currency table, Power BI Exchange Rates