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: AVERAGEX DAX
AVERAGEX in Power BI is an incredibly versatile function. It’s not just for averaging values; it’s also great for trend analysis. You may watch the full video of this tutorial at the bottom of this blog. I discussed the use of AVERAGEX for trend analysis in the Enterprise DNA Learning Summit. A link to the
In this tutorial, I’m going to teach you how to highlight trends by using moving averages in Power BI in various ways. You may watch the full video of this tutorial at the bottom of this blog. We can calculate one moving average and easily transfer the same formula into calculating other moving averages. All
I’ve seen some confusion with iterating functions in DAX whenever I work with Enterprise DNA members in the forum. So we will do a review of what can be achieved using these functions and why you should use them. You may watch the full video of this tutorial at the bottom of this blog. As