Tag: Advanced DAX

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

Change Your Visuals Size By Ranking Logic in Power BI using DAX

Have you ever wanted to create a visualization which changes based on any ranking selection you could make? In this video, I show you exactly how to do it. Think of a scenario where you want to showcase your top 20 clients. Pretend you’re in a meeting saying, “These are the clients that are contributing

Continue reading

Counting Customers Over Time – DAX Example in Power BI

In this example I’m going to run through how you can calculate how many customers you sell to through time using a few functions inside of Power BI in the DAX language. There are actually a few ways you can calculate it, which is why I wanted to create a short tutorial on it to

Continue reading