Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Individual Average Line in Bar Chart

We have Data Like Month || This Year Count || Last Year Count Jan       || 10                      || 5 Feb      ||  15                     || 10 Mar     || 20                       || 15   We ...
Need Help
Tips and Tricks
Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

Are This Year Count and Last Year Count actual measures that you have written or are they input data columns available in your base data file?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Ashish_Mathur  Thanks for your reply.

We are using the Measures for Last and Current Year.
Thanks.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    Hi,

    Do these measures work?

    Average = averagex(all(calendar[Month name]),[This year count])

    Average1 = averagex(all(calendar[Month name]),[Last year count])

    Hope this helps.