Forum Discussion
MCassady
Helper I
Helper IHelp Getting Average of Minimum Daily Values for Specified Month
Hello, I am trying to do a calculation which is the AVERAGE of the MIN temperature values by DAY in the month. For example, if a user picks 2022/10/20 in the slicer, the measure must go and g...
MCassady , You can use a measure like this which will sum above the day level.
sumx(Values(Table[Date]), calculate(Min(Table[Value])) )
amitchandak
Super User
Super UserMCassady , You can use a measure like this which will sum above the day level.
sumx(Values(Table[Date]), calculate(Min(Table[Value])) )
MCassadyHelper I
Helper IHey amitchandak
I am trying something like this in my measure as seen in the example file. Although I am using averagex instead of sumx because I am looking for the average.
I am also using some extra filters that the other working measure is using.
I am not getting my expected results still.