Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |