Forum Discussion

FranckGbadamass's avatar
FranckGbadamass
Helper I
3 years ago
Solved

Seniority in month

Hello friends, I want to calculate the seniority in month for our associates. I went through the age function in Power Query but it only have Days, Year which is not worth for me. As I've a large da...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi FranckGbadamass 

     

    You can add a custom column with

    Duration.TotalDays([End Date] - [Start Date])/30

    I calculate the total days between two dates and divide it by 30 assuming that a month has 30 days. 

     

    If this is not what you want, can you provide some sample data and expected output to explain the requirement more clearly?

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

     

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi FranckGbadamass 

 

You can add a custom column with

Duration.TotalDays([End Date] - [Start Date])/30

I calculate the total days between two dates and divide it by 30 assuming that a month has 30 days. 

 

If this is not what you want, can you provide some sample data and expected output to explain the requirement more clearly?

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.