cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors