Calculating Remaining Day

[Anonymous]

I have a expire date column so I wan't to calculate remaining years,months,days left based on current date.

I'm getting only days when I used DATEDIFF function. 

But I wan't to show year,month,day also in same column

How to achive this

[Anonymous]

I'm getting results like this.

I wan't to show remaining days left based on todays date.

[Shishir22 · Accepted solution]

Hello @Anonymous ,

Not sure what you are doing wrong.

I hope you have already created Calculated column as you mentioned above as-

Remaning Days = Datediff(Today(),'sheet1'[warranty expires],DAY)

Please try creating below one more calculated column-

Converted = QUOTIENT('Sheet1'[Remaining Days], 365) & " years " &  QUOTIENT(MOD('Sheet1'[Remaining Days],365),30) & " months " & MOD(MOD('Sheet1'[Remaining Days],365),30) & " days"

Please mark it as answer if it resolves your issue. Kudos are also appreciated.

[Shishir22]

Hello @Anonymous ,

Please use below DAX on top of your calculation for Remaining Days-

Converted = QUOTIENT('Table'[Remaining Days], 365) & " years " &  QUOTIENT(MOD('Table'[Remaining Days],365),30) & " months " & MOD(MOD('Table'[Remaining Days],365),30) & " days"

Please mark it as answer if it solves your issue. Kudos are also appreciated.