DAX Archives | DataTale

DAX COALESCE

Posted on May 10, 2020May 10, 2020

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 March 29, 2020March 30, 2020

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 […]