cancel
Showing results for
Did you mean:
Highlighted
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.

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
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])

Proud to be a Super User!

4 REPLIES 4
Highlighted
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!

Proud to be a Super User!

Highlighted
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])

Proud to be a Super User!

Highlighted
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.

Highlighted
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!

Proud to be a Super User!

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