Get year services and age ?

[NickzNickz]

Hi...

I have created a table name "Occupation" and "Profile". I prefer to have it in Power Query.

In Table Occupation, i have column name Date_Joined.

1. How can I get the year of service?
2. How can I get Group of Year Service?
   Example:
   

In Table Profile, i have column name Age.

1. How can I get Group of  Age?
   Example:
   

Regards,

NickzNickz

[v-jialongy-msft · Accepted solution]

Hello @NickzNickz 

For your first question, I built this table

Then use this formula to get column year of service

Then use this formula to get column Group of Year Service

For your second question, I built this table

Then use this formula to get column Group of Age

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.