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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
DonnaDonut85
Frequent Visitor

Sum previous 8 rows

Hi guys, 

 

Hoping you can help with this one. We have a requirement to look back at the previous 8 rows of data. If the total days = 8 then we want to highlight this. 

 

This is how we do it in excel 

 

DonnaDonut85_1-1614782028020.png

 

But i am struggling to work out how to do this in BI - any ideas?

 

Thanks! 

 

 

3 REPLIES 3
DonnaDonut85
Frequent Visitor

Thanks @amitchandak,

 

I'm not sure it's a simple explanation but i will try! 

 

So we have a date, project number, total days (to complete project request), average days, days below average and then hopefully we can have a result. The hope is that we can look at the TotalDays in order of date created and if 8 entries or more are below the average days then we would mark in the result column the Total Days - this is what we call the run of 8. This in turn would allow us to highlight on a visual. So the desired outcome would look like the image below. Hopefully this makes sense? 

 

DonnaDonut85_1-1614789270132.png

 

Thanks

 

 

amitchandak
Super User
Super User

@DonnaDonut85 , In power bi, we can not do row operations. so we need to create based on some column values.

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Hi @amitchandak 

 

Just checking to see if you have any ideas to help with this?

 

Thanks!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors