Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Team !
I need a help from your Side.
We have Two dax function same like DatesMTD and TotalMTD .I'm familiar this two dax functions.But Little confusing in Performance wise. Only one difference from this two .
Compare the both Functions which one is the Better for Performance .
Thanks ,
Thennarasu
Solved! Go to Solution.
Performance wise there is no huge difference I guess but it is their place of usage makes them different. Please refer the below blogs to get more info in detail.
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=f5161068-...
https://www.youtube.com/watch?v=BNZSoTYPYQs
https://community.powerbi.com/t5/Desktop/Which-DAX-function-can-use-in-real-time-projects-TOTALMTD-o...
Thanks,
Arul
TOTALMTD is just syntactic sugar for DATESMTD. From https://dax.guide/totalmtd/
TOTALMTD (
<Expression>,
<Dates>
[, <Filter>]
)
is the same as
CALCULATE (
<Expression>,
DATESMTD ( <Dates> )
[, <Filter>]
)
Yes @johnt75
I known the difference both how working same. difference is Syntax and filter paths only.
Main Difference is
DatesMTD is a Table Function
TotalMTD is not a Table Function
my Questions is which one best way to Performance.
Thanks,
Thennarasu
Performance wise there is no huge difference I guess but it is their place of usage makes them different. Please refer the below blogs to get more info in detail.
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=f5161068-...
https://www.youtube.com/watch?v=BNZSoTYPYQs
https://community.powerbi.com/t5/Desktop/Which-DAX-function-can-use-in-real-time-projects-TOTALMTD-o...
Thanks,
Arul
Thanks @Arul
quickly sharing your feedback,
I will go through above mentioned the link.
Thanks,
Thennarasu
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
54 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |