Tag: SUMX

Show Last N Sales Of A Customer Only Using Power BI

We are going to go through quite an advanced tutorial here utilizing┬áDAX formulas in Power BI What I want to show you is how we can work out; how many sales we have made from a specific customer….but, we only want to look at the last three sales or last N number of sales rather

Continue reading

How To Understand Virtual Tables Inside Iterating Functions In Power BI – DAX Concepts

How To Understand Virtual Tables Inside Iterating Function In Power BI - DAX Concepts

I’m going to cover a very interesting topic around virtual tables, and how you can utilize them in Power BI within iterating functions. If you didn’t know it yet virtual tables are the essential ingredient to creating advanced logic inside of Power BI. A lot of the power of these virtual tables comes when you

Continue reading

Cumulative Totals Across Averages & Dynamic Date Logic – Advanced DAX

Cumulative Totals Across Averages & Dynamic Date Logic - Advanced DAX

Today I wanted to cover a unique technique around cumulative totals inside of Power BI. Usually, when we are reviewing cumulative totals we are analyzing them over a date or over a month and year. What we are going to do here though, is we’re going to analyze them versus the month. This particular example

Continue reading

Discover Unique Insights Using TOPN in Power BI

In this video, I wanted to find an insight that was really unique, and hugely valuable for business. I wanted to know the best-selling day for every single product. Not only that, I wanted to be able to look dynamically into any store and analyse the best-selling day for every single product that each store

Continue reading

Advanced Logic Within DAX Iterating Functions – Detailed Example

I want to dive here into iterating functions within the DAX language in Power BI. The reason why I want to spend some time showing you what you can do inside of iterating functions is because it’s such an important concept that you need to learn very well. You might have only just completed some

Continue reading