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.
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
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |