Forum Discussion
ID average by month
Hello guys, I have two columns. One for ID and one for Month. I use letters for each ID. I want to count how many times an ID appears. I get this result with a COUNTA. I block in the next step. I wo...
amitchandak
Super User
Super UserAnonymous , Try a measure like
averageX(values(Table[ID]), calculate(countA(Table[ID])))
or
averageX(values(Table[Monthyear]), calculate(countA(Table[ID])))
Create a column
month year = format([date],"YYYYMM")