0

I have a dataset with dates and hours and a count of the number of events within each hour. I want a measure to take the minimum value of the count within each hour.

data

So the min count by hour column at hour 0 in the above example would show 1 and at hour 1 it would show 2 etc.

I have tried the following DAX but it just shows the same value as the count.

Min count by hour = var _table = 
SUMMARIZE('Arrivals Predictions', 'Arrivals Predictions'[Hour], "count", COUNT('Arrivals Predictions'[AE_AttendNo]))
return
MINX(_table, [count])

Thanks in advance

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.