Daily Maximum value

[isacptj]

Hi  Guys!

I'm trying to create a measure that shows me the maximum daily utilization from a given period.

Using my two tables (Date and transactions), I need to know how many hours of utilization I had in the most productive day and show it with a card view.

Thanks!

[v-xjiin-msft]

@isacptj

Your description is too simple for us to understand your requirement. I have several questions:

1. What is the given period?
2. As you said there are two tables (Date and transactions). What’s the relation between them?
3. To check how many hours of utilization. Did you mean you want to sum the hours?
4. What is the most productive day?

Please share us more detailed information like your source table structures and some sample data with corresponding desired result. And the logic to calculate the values.

Thanks,
Xi Jin.