Tag: Advanced Power BI

Update to Multiple Currencies Management in Power BI – Advanced DAX

There are so many occurrences in financial analysis where we need to integrate exchange rates. Now, I have actually shown an example of how to do this using the LOOKUPVALUE function in Power BI. There is one slight issue with the particular function I went through in the initial video that I didn’t realize at

Continue reading

Isolating Weekday or Weekend Results Using DAX in Power BI

Sometimes calculating averages per day in your Power BI reports isn’t actually enough. You might run into a scenario where you only actually sell during weekdays. You might be a retailer or a restaurant where you only sell in a specific period of days. Now, if you go and run an averaging pattern in Power

Continue reading

Multiple ‘What If’ Parameter Handling In Power BI

Do you want to see how advanced you can get with Power BI? I want to show you here what would most likely be my favourite way to use Power BI. Not just because of what insights you can find, but also the ease of which you can implement this analysis compared to what it

Continue reading

Scenario Analysis Techniques Using Multiple ‘What If’ Parameters – Advanced DAX

Power BI is an incredible tool to run scenario analysis and what-if analysis examples. I’ve actually never seen or come across an analytical tool that is as effective and intuitive to implement this type of complex analytics. The key is that you’ve got to think more analytically about the underlying elements in your datasets than

Continue reading