Tag: DAX Funtions

Understanding LASTNONBLANK For Use In Power BI

Understanding LASTNONBLANK For Use In Power BI

The LASTNONBLANK function is an interesting DAX formula that you can utilize in a number of different ways inside of Power BI. It is not a very used DAX formula because of the complexities around how it calculates results. Most Power BI users, I would presume, don’t even realize that they can utilize the function

Continue reading

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

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

CROSSJOIN is a really effective function that you can utilize inside of Power BI to essentially bind two tables of data together. It’s not just about selecting any two tables from your data sets. What you can do is actually also manipulate tables inside of the CROSSJOIN function so they can be joined in a

Continue reading