In this blog post, we are going to take a look at a question that was asked on the Enterprise DNA forum and use a DAX language Power BI technique to solve it. In case you want to follow along and download the files, just visit the Enterprise DNA forum and go to this link.
Tag: TOPN FUNCTION
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
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
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
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