Forum Discussion

isacptj's avatar
isacptj
Regular Visitor
8 years ago

Daily Maximum value

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!

 

 

Need Help

1 Reply

  • v-xjiin-msft's avatar
    v-xjiin-msft
    Solution Sage
    8 years ago

    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.