Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Alex_0201
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
amitchandak
Super User
Super User

@Alex_0201 , Try with < in place of

 

<= max(DM_WELL_PLAN_OP[Step_no])

 

< max(DM_WELL_PLAN_OP[Step_no])

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@Alex_0201 , Try with < in place of

 

<= max(DM_WELL_PLAN_OP[Step_no])

 

< max(DM_WELL_PLAN_OP[Step_no])

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Pragati11
Super User
Super User

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

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

HI @Alex_0201 ,

 

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

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.