Get year services and age ?

NickzNickz — Tue, 28 Nov 2023 06:19:06 GMT

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.

In Table Profile, i have column name Age.

Regards,

NickzNickz

Re: Get year services and age ?

Anonymous — Wed, 29 Nov 2023 02:30:21 GMT

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.