In today’s blog, we will explore why you should not use the CALCULATE DAX function to obtain Average Per Category and provide some alternative solutions to get the same results you want. You can watch the full video of this tutorial at the bottom of this blog. Getting an Average Per Category in DAX is
Tag: DAX Calculations
Today, we will dive deep into RANKX, a scalar DAX function in Power BI that allows you to return the ranking of a specific number in each table row that forms part of a list of numbers. You can watch the full video of this tutorial at the bottom of this blog. Sample Scenarios We’ll
Retrieving previous period values in Power BI is a common task, but retrieving previous week values requires some special attention. In this tutorial, I’ll discuss two straightforward and versatile methods for obtaining Power BI’s previous week values that can be useful additions to your toolbox – one using DAX and the other using Power Query.
The third pillar in Power BI development is DAX calculations. This tutorial contains a thorough DAX guide for beginners covering the basics on formatting and editing. Frequently used DAX functions are also included in the discussion. DAX Editor Guide Before anything else, here are some DAX Editor tips you need to know: Use Ctrl +
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.