Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

Dangar332's avatar
Dangar332
Resident Rockstar
2 years ago

Hi, Anonymous 
put screen short of error with dax code

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

     

  • Dangar332's avatar
    Dangar332
    Resident Rockstar
    2 years ago

    hi, Anonymous 

     

    update code of  all('calender date')

    remove update code of all('calender date'[date])  -- remove red part from all and put  all('calender date')

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, Thanks for replying

    when I select 2022 year the avearge of each month is like below


    When I select 2023 in year (open_date) the 12 months rolling average is like below


    But when I didn't give any filters and want to check respective years 12 months rolling averages it's changing , like below


    I want to show rolling avearges for every year separately in trends 

    Please reply
    Thanks in advance