Tag: SUMX

Showing The Last Three Customer Sales Using The TOPN Function

I’m going to cover some great functions here in Power BI that are very useful across a variety of analytic scenarios. Some of these functions can help us work out the last three customer sales. What I want to show you is how to work out the sales from a specific customer, but by only

Continue reading

How To Use Iterating Functions To Fix Total Issues In Power BI – DAX Concepts

How To Use Iterating Functions To Solve Total Issues In Power BI - DAX Concepts

I’m going to show you today how to use iterating functions when you’re trying to fix Total issues in Power BI. When I go through the questions posted on the Enterprise DNA support forum for members, I see a lot of people having issues with the Totals they get on their report regardless if they’re

Continue reading

Cumulative Totals Based On Monthly Average Results In Power BI

Today, I wanted to cover a unique technique around cumulative totals based on monthly average results in Power BI. To set the date range for the calculation of monthly average results, we will be using a date slicer. A Power BI slicer is an alternative for filtering which narrows the portion of the dataset shown in

Continue reading

Getting Started With The “What If” Parameter In Power BI

The possibilities of using the What If parameter in Power BI is deemed endless. It gives users and businesses the flexibility to design a solution for the critical answers and insights that they need. In the recent Enterprise DNA learning summit, we had a successful session regarding the usage and implementation of What If Parameter

Continue reading

Master Virtual Tables in Power BI Using DAX

In this blog post, I’ll run through a truly powerful analytical technique which I’m confident will WOW anyone. Virtual tables are a unique analytical technique that you can use to visualize interesting insights inside Power BI. The example I’ll show is just one of the many techniques you can apply. I use the term “algorithms”

Continue reading