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
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.