Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
How would be possible to use MAX work out the below? i need to find out the max with calcuation in mind below. I can do this based on a hour window and a 15 min window but i need to find out what the MAX is if we had the calcutaion in mind below. So for example if it was 10:45 to 11:45
time | coy | |||
A | 22-00 | 6191 | 21317 | this adds A,B,C and D |
B | 22-15 | 5484 | 20242 | this adds B,C,D and E |
C | 22-30 | 1198 | 15943 | |
D | 22-45 | 8444 | 16256 | |
E | 23-00 | 5116 | 9323 | |
F | 23-15 | 1185 | 6058 | |
G | 23-30 | 1511 | 4873 | |
H | 23-45 | 1511 | 3362 | |
I | 19-08 | 1851 | 1951 |
Below you can see that it shows max for 15m which is 4171 and the hour which shows 15612 but i need to work out MAX based on 15 minute, so instead of every hour i need to work out each 15 minute window by just increaseing by 1 like 10:15 - 11:15 and seeing if that has a higher max.
This is also the code i use to get the MAX hour by using a slicer
Hi @Anonymous
Could you show an example of 'ItemTracking'[Hour Window], [Normal]?
Where is the last column used?
Based on my understanding, you want to show 10:15, 10:30, 10:45, 11:00, 11:15.... in the Axis, the the max value (in A, B, C...) per time period in the Y-axis.
Right?
Best Regards
Maggie
My issue is that can not work out a Max between each 15 minute window against and hour so for example:
10:00 - 11:00 i can work this out but what if the max was higher in this time wndow 10:15 - 11:15 this is what i need to know. This can be done very easy in excel but can not get my head round it in Power BI
Sorry this very hard to explain..
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.