Tag: TOPN FUNCTION

TOPN DAX To Showcase Top Customers This Period vs Last Period

TOPN DAX To Showcase Top Customers This Period vs Last Period

In today’s post, I want to show you a unique way of using the TOPN DAX ranking function to showcase your top clients over multiple periods. You can also watch the accompanying Power BI tutorial video below this post for more help. You may watch the full video of this tutorial at the bottom of

Continue reading

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. You may watch the full video of this tutorial at the bottom of this blog. Using TOPN as a virtual ranking function allows you to dynamically produce the top and bottom

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. You may watch the full video of this tutorial at the bottom of this blog. This is actually a unique question that was raised at the Enterprise DNA Support

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. You may watch the full video of this tutorial at the

Continue reading