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,
I need to get Cumulative Running Time of running pumps using DAX
I have created 3 measures for that,
First for getting Previous row,
Second for subtracting the current row from previous row,
Third to get cumulative runnning time
But I am facing a small issue, I have explained my issue below the screenshot
Here are the formula for Measures:
So in the sceenshot you can see that in Time column, Difference between 2 consecutive rows is 10 mins. In the column run time1 we can see the cumulative running time, it is working fine but at some point of time when Difference b/w 2 consecutinve rows is greater than 10 mins there it is showing incorrect value, I need to fix this.
Can anyone help me in this issue?
If you've any question feel free to ask.
Thanks and Regards
Mihir
Hi @miiihiir ,
Could you please provide a pbix file without privacy inforamtion and desired output with more details? What the desired output in the red mark?
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
43 | |
22 | |
21 | |
16 | |
15 |
User | Count |
---|---|
46 | |
28 | |
25 | |
18 | |
17 |