Tag: TOPN FUNCTION

First N Business Days Revisited – A DAX Coding Language Solution

Let’s take another look at the problem discussed in this tutorial, which dynamically compared the first N business days of each month. This problem was based on a query from an Enterprise DNA member on our forum, where he wanted to dynamically look and compare the first 5, 10, 15, and 20 billable days (the

Continue reading

Using DAX TOPN To Calculate Last N Weeks Trend

This tutorial will discuss and solve Problem Of The Week #5 in the Enterprise DNA forum using the DAX TOPN function. The problem requires a solution with 4 requirements. One requirement of the problem is to calculate the dynamic Last N Weeks Trends of a COVID-19 data report. You can watch the full video of

Continue reading

Solve A Data Analytics Challenge W/Power BI Accelerator

Solve A Data Analytics Challenge W/Power BI Accelerator

For this post, I’ll walk you through a real-life scenario where you might find yourself in a similar situation where you’re asked for something by a stakeholder and you need to create a report quickly based on what they are asking for. This is exactly what the Power BI Accelerator data analytics challenge is all

Continue reading

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