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

I’m hoping that the community can help me to clarify YTD performance vs using calendar table offsets. I have always heard that TI (time intelligence) functions perform badly but from what I'm see...

General Comment

Need Help

FBergamaschi
1 year ago
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

FBergamaschi

Super User

1 year ago

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