Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |