yrs

Hi All I've been playing with the data below. I'm trying to unpivot the age ranges in power query. When I do this and then try to load it to the data model all the decimals get removed. Instead of decimals I just get zeros. What am I doing wrong? Many thanks Miles <tbody> User Type...

I have a Years of Service column calculating correctly, I also have another column that will populate each row with "10 YRS" "15 YRS" "20 YRS" and "25 YRS" if applicable by comparing 10years 0 months etc. A user wants the column to populate for the entire 12 months of the milestone anniversary...

Dear Gents, I've got a data prepared by dates since 5 yrs back till today. I'd like to analyse the first year and the second year...etc. and from the inception to 5 yrs. i.e: <tbody> 08/01/2017 <tbody> 09/01/2017 . </tbody> </tbody> . . <tbody> 11/07/2018 Hope is clear...

Hello Experts Today, I stuck with a different problem, I need to calculate numbers of days between 2 dates and also calculate the gap of days in yrs also. <colgroup><col><col><col><col span="2"><col span="2"><col></colgroup><tbody> See the below example <tbody> <tbody> Start Date...

I have two dates subtracted which gives yields 867 How to convert to ? Yrs ? Mths ? Days