DAX COALESCE

Posted on

DAX, the COALESCE function Don’t you hate it when a card looks like this? Meet COALESCE This function was introduced in March 2020 and instantly became a favourite of mine.  Although I think a more appropriate name would be ifblank! Wrap it around your DAX statement and the Default Measure will be presented instead of […]

DAX YTD & LYTD

Posted on

DAX for Financial Years I use these two measures quite a bit. YTD Total Sales is straight forward and calculates in this case a sum of sales from the 1st of July to today. The trick is what to do when you want to compare the same period for the previous year. That is where […]