Tag: TOPN DAX

Discover Unique Insights Using Power BI TOPN Function

In this video, I wanted to find an insight that was really unique, and hugely valuable for business. Here, I used the Power BI TOPN function. 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

Continue reading

Ranking Insights Using TOPN In Power BI

In this article, we will explore how we can use the TOPN function in Power BI. You will really enjoy seeing the immense amount of ways that you can utilize this function. TOPN is such a powerful function and there are so many little nuances in how it operates in different contexts. I’m going to

Continue reading

Showcase The Top Result Name Within A Card Visualization Using Power BI

A recent question came out of the Enterprise DNA Support Forum where a member needed to work out what was the top value that they had for a particular result. You can review the entire forum post here – Product Name as Measure for Highest Sales Product They didn’t require just any value. They actually

Continue reading

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