cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Partisan
Post Partisan

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.

0.PNG

But I have a little issue here. It doesn't seem to add 0 into the first row:

1.PNG    2.PNG    4.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IX
Super User IX

Re: Running total and adding rows

@Alex_0201 , Try with < in place of

 

<= max(DM_WELL_PLAN_OP[Step_no])

 

< max(DM_WELL_PLAN_OP[Step_no])



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

4 REPLIES 4
Highlighted
Super User IV
Super User IV

Re: Running total and adding rows

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





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Highlighted
Super User IX
Super User IX

Re: Running total and adding rows

@Alex_0201 , Try with < in place of

 

<= max(DM_WELL_PLAN_OP[Step_no])

 

< max(DM_WELL_PLAN_OP[Step_no])



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Highlighted
Post Partisan
Post Partisan

Re: Running total and adding rows

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. 

4.PNG

Highlighted
Super User IV
Super User IV

Re: Running total and adding rows

HI @Alex_0201 ,

 

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

 

Thanks,

Pragati





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors