Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 =
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 |
---|---|
93 | |
85 | |
78 | |
67 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |