Tag: Power BI DAX

Show Days Before Or After A Selected Date Using Power BI

Show Days Before Or After A Selected Date Using Power BI

As we work through this tutorial I will show you some truly powerful analytics that you can complete inside of Power BI. It is amazing how flexible you can make your solutions in Power BI if you get the set up right. When I say set up, I mean your data model first and foremost

Continue reading

Create Dynamic Cumulative Totals Using DAX In Power BI

Create Dynamic Cumulative Totals Using DAX In Power BI

In this tutorial, we’re going to do a deep dive into the cumulative total formula combination that can be used in Power BI. Cumulative totals are a great way of showing trends over time and then also showcasing differences in trends between different timeframes. There is a common combination of DAX functions to use that

Continue reading

Formatting DAX Code In Power BI

Effort here will pay dividends later Placing effort into formatting your DAX code will makeĀ a huge difference as you build out your data models in Power BI. DAX, at times is a confusing language as it is, so as soon as you get into the slightly complex territory unformatted DAX code becomes almost impossible to

Continue reading