DAX for Average the result of the measure by month
Hi I would like to average the result from one of my measure (Column B). According to the above picture, column B is the result from this measure HC-Resign HC = CALCULATE(COUNT('HC'[Employee ID]),'Attrition'[PE]="1") Resign = CALCULATE([Resign], filter(ALL('Data as of_LookUp'[Data as of]),'Data as of_LookUp'[Data as of]<MAX('Data as of_LookUp'[Data as of]))) And after I got the column B, I tried to average them to result in column D, using ALL / FILTER anything that I can think of but it doesn't work. So anyone please give me the light. Thank youu!
