Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi. Thanks again for help!
You guys helped me to solve a probelm with a running total by adding this measure which also adds 0 into the first row.
But I have a little issue here. It doesn't seem to add 0 into the first row:
Solved! Go to Solution.
@Alex_0201 , Try with < in place of
<= max(DM_WELL_PLAN_OP[Step_no])
< max(DM_WELL_PLAN_OP[Step_no])
@Alex_0201 , Try with < in place of
<= max(DM_WELL_PLAN_OP[Step_no])
< max(DM_WELL_PLAN_OP[Step_no])
Hi @Alex_0201 ,
The dax expression what you are using is checks if there is a STEP_NO less than or equal to the STEP_NO at the current row.
So, if you take example of your 1st row where STEP_NO = 1, you don't have anything less than 1 in your data.
Also, adding 0 to it will not create a difference.
So, wanted to check why you are concerned with additon of 0 to your 1st row?
Thanks,
Pragati
Hi @Pragati11 because I need to have 0 in the column Total time in the step_no 1. And move the hole column Total time down starting from the value 48.
HI @Alex_0201 ,
In that case in your DAX, replace "<=" with "<" everywhere in the dax.
Thanks,
Pragati
User | Count |
---|---|
127 | |
72 | |
70 | |
58 | |
53 |
User | Count |
---|---|
192 | |
96 | |
67 | |
64 | |
54 |