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.
Good Afternoon,
I have the following volumes in the given times:
09:30:00 = 5000
09:45:00 = 100
10:00:00 = 1000
I want to display this values as an aggregation of the actual value with the earlier value, being this way>
09:30:00 = 5000
09:45:00 = 5100
10:00:00 = 6100
and so on ...
Is that possible?
Ps: my time value is a string value.
Solved! Go to Solution.
That looks like a simple cummulative sum. A calculation like the following should work:
Cummulative Volume = CALCULATE( SUM(table1[Volume]) , FILTER( All( table1[Time] ), table1[Time] <= MAX( table1[Time] ) )
I'm not sure if you can do MAX over string values, this used to be an issue in earlier versions of the engine. If so you may need to convert your time to a datetime data type.
That looks like a simple cummulative sum. A calculation like the following should work:
Cummulative Volume = CALCULATE( SUM(table1[Volume]) , FILTER( All( table1[Time] ), table1[Time] <= MAX( table1[Time] ) )
I'm not sure if you can do MAX over string values, this used to be an issue in earlier versions of the engine. If so you may need to convert your time to a datetime data type.
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |