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
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
