Forum Discussion
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...
Sorry, my column labels are bit unclear. The "total" column is a measure that averages the total of 2 other columns called Zone 3 and GS.FW... Total is the average flow for each hour, over a given slicer date range. However, I would like the average of all data & times, like the number 6,223 shown at the bottom of the Total column. Then I want to divide each hour by that number so I normalize on that number (the avg of all times and dates within the range). Everytime I try it, though, I just get 1.00 because averages only for that hour.
Thanks