Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Running total and adding rows

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:

        

Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , Try with < in place of

     

    <= max(DM_WELL_PLAN_OP[Step_no])

     

    < max(DM_WELL_PLAN_OP[Step_no])

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , Try with < in place of

     

    <= max(DM_WELL_PLAN_OP[Step_no])

     

    < max(DM_WELL_PLAN_OP[Step_no])

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi Anonymous ,

     

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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. 

      • Pragati11's avatar
        Pragati11
        Super User
        6 years ago

        HI Anonymous ,

         

        In that case in your DAX, replace "<=" with "<" everywhere in the dax.

         

        Thanks,

        Pragati