topic Re: 1899 OR SOME OTHER YEAR in DAX Commands and Tips

1899 OR SOME OTHER YEAR

RIDWIV — Tue, 25 Apr 2023 11:58:54 GMT

While substracting two year

st1-st2 = ('EKYC accountopen stages'[stage1_completed_at]-'EKYC accountopen stages'[stage2_completed_at]) i am getting value

Wed, 08 Jan 2020 14:22:00- Wed, 08 Jan 2020 14:22:00 = Sat, 30 Dec 1899 00:00:00

i want exact result

Re: 1899 OR SOME OTHER YEAR

tamerj1 — Tue, 25 Apr 2023 12:15:17 GMT

Hi RIDWIV
Please try

Mst1-st2 = INT ( 'EKYC accountopen stages'[stage1_completed_at] - 'EKYC accountopen stages'[stage2_completed_at] )

Re: 1899 OR SOME OTHER YEAR

RIDWIV — Tue, 25 Apr 2023 13:19:50 GMT

tamerj1 i tried but the date is showing different year. ie,1899, sharing the screenshot

Re: 1899 OR SOME OTHER YEAR

tamerj1 — Tue, 25 Apr 2023 13:59:30 GMT

RIDWIV
Strange! It should work. However, please try

Mst1-st2 = DATEDIFF ( 'EKYC accountopen stages'[stage2_completed_at], 'EKYC accountopen stages'[stage1_completed_at], DAY )

Re: 1899 OR SOME OTHER YEAR

RIDWIV — Wed, 26 Apr 2023 05:12:26 GMT

tamerj1 can we get the difference like Or 1 year, 1 month, 8 days including the end date.

Re: 1899 OR SOME OTHER YEAR

tamerj1 — Wed, 26 Apr 2023 08:45:20 GMT

RIDWIV

Please try

Mst1-st2 = VAR Days = DATEDIFF ( 'EKYC accountopen stages'[stage2_completed_at], 'EKYC accountopen stages'[stage1_completed_at], DAY ) VAR Years = QUOTIENT ( Days, 365 ) VAR Months = QUOTIENT ( MOD ( Days, 365 ), 30 ) RETURN Years & " Years, " & Months & " Months & " & Days & " Days"