Reply
Frequent Visitor
Posts: 2
Registered: ‎01-30-2019

Caculated MAX based on time window

[ Edited ]

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

 

 timecoy  
A22-00619121317this adds A,B,C and D
B22-15548420242this adds B,C,D and E
C22-30119815943 
D22-45844416256 
E23-0051169323 
F23-1511856058 
G23-3015114873 
H23-4515113362 
I19-0818511951 

 

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.

 

throu.png

 

This is also the code i use to get the MAX hour by using a slicer

 

Max per Hour Window =
MAXX(
    KEEPFILTERS(VALUES('ItemTracking'[Hour Window])),
    CALCULATE([Normal])
)

 

 

Community Support Team
Posts: 2,524
Registered: ‎03-15-2018

Re: Caculated MAX based on time window

[ Edited ]

Hi @DAMO16466464644

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

Highlighted
Frequent Visitor
Posts: 2
Registered: ‎01-30-2019

Re: Caculated MAX based on time window

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..