Tag: TOPN FUNCTION

When To Use TOPN In Power BI – A DAX Formula Review

This tutorial will review how to use TOPN as a virtual ranking function to generate interesting insights based on ranking logic in Power BI. Using TOPN as a virtual ranking function allows you to dynamically produce the top and bottom results for any measure. This example will show how to work out the locations that

Continue reading

How to Compare Current Sales to Previous Best Month in Power BI

In this tutorial, we’re going to learn more about the advanced time intelligence feature in Power BI to compare current sales to the previous best month. This is actually a unique question that was raised at the Enterprise DNA Support Forum. And as soon as I heard it, I thought wow! We can actually do

Continue reading

Find Your Top Products For Each Region in Power BI Using DAX

If you are a business selling products in many different stores or across many different regions, then you will want to understand if there is any commonality in your top or bottom selling products. You would want to discover your top products per region. In this example, I run through how you can find your

Continue reading