Forum Discussion
12 months average
Hi all, I have req as doing average for each month Before I was showing count (I'd) for each date, mknth, year Now I want to show average like In Jan if I have count of id 700 then avg will b...
Hi, Anonymous
update code of all('calender date')
Cumulative Total =
CALCULATE(COUNT('MATTER TABLE'[ID]),
FILTER (
ALL ('Calendar Date'),
'Calendar Date'[Date] <= MAX ('Calendar Date'[Date] ) &&
'Calendar Date'[year] = year(MAX ('Calendar Date'[Date] ))
)
)
Average Test = DIVIDE([Cumulative Total],MAX('Calendar Date'[Month Sort]),0)
Thanks for replying
calculation error in measure [ Cumulative Total] :dax comparision operation do not support comparing values of type text with values of type integer. Consider using VALUE or FORMAT Function
I tried foemat and value also, shoiwng below error
A single value for column 'YEAR' in table 'Calendar Date' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
Please reply back
Thanks