Category: Data Visualization

Deep Dive Into RANKX – DAX Formula Concepts In Power BI

RANKX is a very unique DAX function that requires a deeper level of thinking around its logic and also in how it actually works when running a calculation in a particular context (for example a table or chart inside of Power BI). Each different parameter within the RANKX function can change the way in which it

Continue reading

Filter Your Data By Unique Financial Years & Quarters – Power BI Modeling Technique

Sometimes you want to filter your data by financial or fiscal years versus filter by calendar years. This particular tutorial is going to cover how you can do just that. What we’re going to do is use a current date table that we may already have inside of our model. If you want to learn

Continue reading

Cumulative Totals In Power BI Without Any Dates – Advanced DAX

In this example, I’m going to show how you can create Cumulative Totals which are not over dates in Power BI. To create cumulative totals over dates inside of Power BI is not too difficult. There’s a set of formula pattern that you can utilize and reuse for whatever type of cumulative total results you

Continue reading

Fixing Incorrect Totals Using DAX Formula Techniques In Power BI

Getting totals correct inside your Power BI reports can sometimes be the most frustrating thing when utilizing DAX measures. The key to understanding how totals are calculated is to learn in-depth, how context works inside of Power BI. In this tutorial, I’ll go through several different examples of how to fix totals. By doing this,

Continue reading

How To Use Q&A (Natural Language Query) In Power BI

The Natural Language Query capability in Power BI is amazing. There is so much you can discover just by writing these Google-like queries inside of the search bar and dashboards in Power BI online. After you view and go through this tutorial,¬†I think you’ll be amazed at how advanced you can get with Natural Language

Continue reading