Tag: Advanced DAX

A Deeper Understanding Of Advanced RANKX

Advanced RANKX - How To Understand This Function More Deeply

This tutorial will go through an advanced example on the DAX function RANKX in Power BI. This is a breakout session from the Learning Summit Workshop in Enterprise DNA Online. The RANKX function gives you valuable insights when you use it for a range of different contexts in your report page. However, it can also

Continue reading

Manage Multiple Date Calculations In Your Fact Table – Advanced Power BI Technique

In this tutorial, I’m going to teach you how to manage multiple date calculations in your Fact Table in Power BI. This is a frequent question in the Enterprise DNA Support Forum. These multiple dates could be order dates, ship dates, expiration dates, and arrival dates, among many others. This information might be located within

Continue reading

Top Customer Per Product – Power BI Analysis

This tutorial involves finding out your top customer per product using an advanced Power BI analysis. This example perfectly shows how Power BI can generate practical insights once you utilize it effectively. There’s just no other tool out there that’s as versatile and flexible as Power BI. In Power BI, you can quickly and easily

Continue reading

Optimizing Your Power BI Formula Using Advanced DAX Functions

I’ll go over some interesting concepts that involve using several table functions to optimize your Power BI formula. I’m going to use an example from the Enterprise DNA Support Forum where one of the members asked if it’s possible to add a filter while using the SUMMARIZE function. This is quite common for scenarios when

Continue reading

Advanced Tips To Optimize Your Power BI Table

This tutorial showcases some advanced tips to optimize your Power BI table. I’ll show you how to break out your large table into multiple ones. This concern is quite common across legal database systems with huge flat files of information. Huge tables need to be broken down into simpler tables for easy information management. Most

Continue reading