Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Average Per Hour

Hello all,   I need to display in a visual Card the average per hour in total. I have the following Fact table: Id QuantityExecuted DimStartTime_id 1 20 11:54:51 2 1 11:55:12 3 ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , create hour as time  in your table 

    or use hour column

     

    example

    averagex(values(Time[Hour]), calculate(sum(Table[Quantity])))

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , create hour as time  in your table 

or use hour column

 

example

averagex(values(Time[Hour]), calculate(sum(Table[Quantity])))

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello amitchandak ,

     

    Thank you for your reply. It was correct. I found out some example but was not totally correct.

     

    Thanks and have a nice day,

    Rui