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 utiliza...
Need Help
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.