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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Learner_SG
Helper IV
Helper IV

Select the 4 highest values from 2 days and different time intervals.

Hi,

could help me on this matter pls. I have a summarized table as shown below. I need to select the 4 highest value from last 6th and 7th day and from each time intervals. The maximum water consumed from each time interval is chosen .So the highlighted values in the 2nd image will be the one that need to be selected. I have attached a sample data.

Learner_SG_0-1652848300325.png

Learner_SG_1-1652848176684.png

https://docs.google.com/spreadsheets/d/13j1zsIoI9CMrGhfMHV9aMfSVcRT9lgVy/edit?usp=sharing&ouid=10671...

 

1 ACCEPTED SOLUTION
sturlaws
Resident Rockstar
Resident Rockstar

Hi, @Learner_SG,

I think the answer for your question can be found here:
Filtering the Top 3 products for each category in Power BI - SQLBI

 

I have made an example based on the data you provided:
example 

 

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

View solution in original post

1 REPLY 1
sturlaws
Resident Rockstar
Resident Rockstar

Hi, @Learner_SG,

I think the answer for your question can be found here:
Filtering the Top 3 products for each category in Power BI - SQLBI

 

I have made an example based on the data you provided:
example 

 

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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