Tag: Advanced DAX

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

New vs Existing Customers – Advanced Analytics w/DAX

If you’re an online retailer or a high frequency sales operation, then understanding your customer base, like if they are new customers or existing customers, is a really high quality insight. You’ll want to dive into this type of analysis because you need to evaluate if most of your sales are attributed to people who

Continue reading

Managing Seasonality in Budgeting Analysis – Advanced Power BI

Completing budgeting analysis in Power BI is unfortunately just not that easy. What I’m going to go through today is possibly the most advanced technique that you can get to with budgeting as we need to incorporate some seasonality into our budgeting numbers. I detail this quite extensively in the video tutorial, so there’s lots

Continue reading

Advanced Logic Within DAX Iterating Functions – Detailed Example

I want to dive here into iterating functions within the DAX language in Power BI. The reason why I want to spend some time showing you what you can do inside of iterating functions is because it’s such an important concept that you need to learn very well. You might have only just completed some

Continue reading