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 Community,
I am having issues with the performance of my dax measures. I am trying to calculate a opening balance/ running total upto the selected date minus 1 month.
Hoping somone can provide guidance on how to improve the performance of it.
Below are the two DAX Measures
DAX
OpenBalance =
Solved! Go to Solution.
hi @databot_kd
VAR App = CALCULATE(SUM('GL'[amount]), 'GL'[Date] <= EoMDate , 'GL'[data_source] = "glaph") + 0
Remove +0 from measure it will unnecessary add 0 value to add the levels.
i hope it may reduce query time.
Hi @databot_kd
You can also take filter function which return the query much faster rather than row by row check the condition.
CALCULATE(SUM('GL'[amount]), 'GL'[Date] <= EoMDate , 'GL'[data_source] = "glaph")
Try to take filter finction for this condition.
https://www.youtube.com/watch?v=jcOa4sEMDDs
Filter function works faster than without apply filter condition.
I hope I answered your question!
Hi @databot_kd
You can also take filter function which return the query much faster rather than row by row check the condition.
CALCULATE(SUM('GL'[amount]), 'GL'[Date] <= EoMDate , 'GL'[data_source] = "glaph")
Try to take filter finction for this condition.
https://www.youtube.com/watch?v=jcOa4sEMDDs
Filter function works faster than without apply filter condition.
I hope I answered your question!
hi @databot_kd
VAR App = CALCULATE(SUM('GL'[amount]), 'GL'[Date] <= EoMDate , 'GL'[data_source] = "glaph") + 0
Remove +0 from measure it will unnecessary add 0 value to add the levels.
i hope it may reduce query time.
User | Count |
---|---|
78 | |
75 | |
62 | |
60 | |
46 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |