Tag: CROSSJOIN Function

Data Visualization DAX Enterprise DNA Power BI

RANKX Considerations – Power BI And DAX Formula Concepts

By Sam McKay, CFA on

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). What you don’t want with RANKX DAX function is to start receiving results and not really

Continue reading
Posted in: , , , , , , ,
5 comments
DAX Power BI

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

By Sam McKay, CFA on
CROSSJOIN function

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. CROSSJOIN is a really effective function that you can utilize inside of Power BI to essentially bind two tables of data

Continue reading
Posted in: , , , , , ,
One comment