Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How To Create Measures Over Hours

Hello ,   I have read through many of the other messages, but I can't seem to get this one to work. I have sensor data (Please, find it posted) and want to create two measures over 24 hours: 1-) ...
Need help with DAX
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 
    Here is your file updated based on 34hr averages only at end of each day https://www.dropbox.com/t/XvUdc0zpksXlL9t8
    Your report looks like this

    Once you start having values that generate averages above 4 then "Blank" card will start showing numbers.
    Please let me know if you are now fully satisfied. Thank you.

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous 
Refer to updated file https://www.dropbox.com/t/6BJyRDp0745ewhPL
You need to create a new date (date only) column:

 

Date = DATE ( YEAR ( Data[Date/Time] ), MONTH ( Data[Date/Time] ), DAY ( Data[Date/Time] ) )

 

The report looks like this

Please let me know if this what you need.

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

There was an error in the "Above 34" measure. I edited and corrected in the previous comments. Download link remains the same.

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi Anonymous 
    Here is your file updated based on 34hr averages only at end of each day https://www.dropbox.com/t/XvUdc0zpksXlL9t8
    Your report looks like this

    Once you start having values that generate averages above 4 then "Blank" card will start showing numbers.
    Please let me know if you are now fully satisfied. Thank you.