TotalMTD , TotalYTD is very slow for a specific table

sathishdgl — Sun, 10 Sep 2023 04:40:48 GMT

I created following measure in 2 tables, orders and shipments. Both are showing correct value. However measure in orders loads very fast but same measure formula in shipments is extremely slow

TOTALMTD( orders[amount], calendar[date])

time : 1524

is very fast but

TOTALMTD (ship[amount], calendar[date])

is slow

time :6454

calendar is not marked as date table because it is having duplicates. i don't mind, because it is showing correct values

Re: TotalMTD , TotalYTD is very slow for a specific table

some_bih — Sun, 10 Sep 2023 09:12:28 GMT

Hi sathishdglDAX functions like TOTAMTD or TOTALYTD are from group Time Intelligence which means the best work on Calendar / Date table. It is good for you to compare performance and similar, but to implement best practice create Calendar / Date table (and mark it without duplicate) and after that check perfomance.

Hope this help, kudos appreciate.

topic TotalMTD , TotalYTD is very slow for a specific table in DAX Commands and Tips

TotalMTD , TotalYTD is very slow for a specific table

Re: TotalMTD , TotalYTD is very slow for a specific table