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.
Hello all
In the picture below, i have 4 columns that display the 4 quarters of the year.
Now, i need Q2 to be the Sum of Q1 and Q2. Q3 = Q1+Q2+Q3 and same for Q4.
So Q4 would be 2'361'693.
Can i do that with a measure?
Any ideas?
Best regards
Solved! Go to Solution.
@Anonymous
Please change the formula to this one:
Cumulative_Actual = CALCULATE ( SUM ( Sheet1[Value] ), FILTER ( ALLEXCEPT( Sheet1, Sheet1[frango]), Sheet1[Quarter] <= MAX ( Sheet1[Quarter] ) ) )
Aslo you can see the formula in this workspace
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 |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |