Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am using a running formula for a measure further below. I show running curves on graphs with dates on X axis.
For one specific running measure I need to add the sum of a column in another table (or its running equivalent - whatever is easier).
SUM doesnt seem to work because it calculates to 1 scalar value
SUMX doesnt seem to work either.
Ideas?
Solved! Go to Solution.
I was able to solve this by adding the columns on the same DAX calculating the running
Hi @Mike_Mace ,
Your DAX seems to be correct. I created a test file and show the correct result.
You could check the relationships.
Here is my test result.
Here is my test file for your reference.
Hi @v-eachen-msft ,
Yes running DAX works thanks for confirming. So now I have two running columns on that DAX.
I need a third column which adds the two columns per row. That would make14th of Feb sum 6 and 19th of March 15 on table below.
This is where i tried SUMX but couldn't get anywhere.
I was able to solve this by adding the columns on the same DAX calculating the running
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |