Tag: Power BI Exchange Rates

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

Power BI Exchange Rates: An Update To Multiple Currencies Management

There are many instances with financial analysis wherein we need to integrate exchange rates, and we can do this easily in Power BI. You may watch the full video of this tutorial at the bottom of this blog. I have actually shown an example of how to do this using the LOOKUPVALUE function in Power

Continue reading