Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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..