YOY total members (Per region, category, FTE, country and Age Group)

[Nordin]

Hi All,

I am a newbie to PowerBI and was hopping to get some help/guidance to what I am trying to achieve.

I have a excel worksheet with the the following columns, 

Internal ID, Age, Age Group, Country, FTE, Internal ID, Main Region, Member Category Sub Region and Year

I am trying to do a YOY comparison based on the dates in the Year column. But unfortunately I don;t know how to do this!

Please help out here.

Kind regards,

Nordin

[v-yulgu-msft · Accepted solution]

Hi @Nordin,

To calculate year over year comparison, you caould have a look at below examples:

Year over year graphic

Custom year-over-year calculation in DAX

For more advice, please follow this article to provide more detailed information.

Best regards,

Yuliana Gu