DAX Year to date measure, Time Intelligence performance vs using offsets performance

Hi timosborn,

the thing was that TI calculations runs pretty slow in DirectQuery (but this is not so true anymore). TI is definitely better than any alternative most of the times as Microsoft has optimized those functions.

So my suggestion after 14 years of DAX is to go ahead with the schema CALCULATE + built-in tie intelligence functions like DATESYTD all the time you can

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI