Tag: CROSSJOIN Function

DAX Weekly Calculations – Power BI Time Intelligence Issues

Time Intelligence Issue of a DAX Weekly Calculations

In today’s tutorial, I’ll provide some techniques and tips on how to deal with common problems caused by DAX weekly granularity in time intelligence calculations. You can watch the full video of this tutorial at the bottom of this blog. I recently did a tutorial on obtaining Previous Week Values in Power BI. Since then,

Continue reading

Ranking Analysis In Power BI: Advanced Insights From Combined Data Sets

In this tutorial, I’m going to show you some advanced ranking analysis in Power BI. As an example, I’m going to use the report that I submitted for the 10th Power BI Challenge on the Enterprise DNA forum. I have discussed the other pages in this report in other tutorials. For now, I would like

Continue reading

RANKX Considerations – Power BI And DAX Formula Concepts

RANKX is a very unique DAX function that requires a deeper level of thinking around its logic and in how it actually works when running a calculation in a particular context (for example a table or chart inside Power BI). You may watch the full video of this tutorial at the bottom of this blog. What

Continue reading

How To Use The CROSSJOIN Function – Power BI & DAX Tutorial

CROSSJOIN function, how to use the crossjoin function post image

For this blog post, I want to demonstrate the CROSSJOIN function. I’m going to show an example of how I used it, and then explain when and where you can use it as well. You may watch the full video of this tutorial at the bottom of this blog. CROSSJOIN is a really effective function

Continue reading