Forum Discussion

JBGilbert's avatar
JBGilbert
New Member
3 years ago

Normalize Hourly Averages by the Daily Average

I have a list of hourly data and using the slicer to average over a date range.  In the table below, I have the average hour-by-hour data shown in a table (measures).  At the bottom of the table is t...
Shaurya's avatar
Shaurya
Icon for Memorable Member rankMemorable Member
3 years ago

Hi JBGilbert,

 

Use the following DAX formula to create a new column:

 

Average Ratio = 'Table'[Total]/AVERAGE('Table'[Total])

 

 

Works for you? Mark this post as a solution if it does!