Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Satish_Kumar
Helper V
Helper V

how to calculate the number of days between two dates which are in different column?

 
1 ACCEPTED SOLUTION

Hi @Satish_Kumar,

Please use the following formula to calculate variance update column.

variance update = IF('NTT 16-17'[Last Payment on]<'NTT 16-17'[DueDate],DATEDIFF('NTT 16-17'[Last Payment on],'NTT 16-17'[DueDate],DAY),1*DATEDIFF('NTT 16-17'[DueDate],'NTT 16-17'[Last Payment on],DAY))


1.PNG


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

10 REPLIES 10
Thiyags
Helper II
Helper II

You can use the DATEDIFF function to calculate the difference between the two dates.

 

@Thiyags

its giving wrong answer.

 

Hi @Satish_Kumar,

 

What is the wrong answer? Please give more info.

 

 

@manderson

its only subtracting the days

if 12/2/2016-17/4/2016

answer is -5 only which is wrong

its only subtracting the days

if 12/2/2016-17/4/2016

answer is -5 only which is wrong

e2.pnge1.png

Hi @Satish_Kumar,

Please use the following formula to calculate variance update column.

variance update = IF('NTT 16-17'[Last Payment on]<'NTT 16-17'[DueDate],DATEDIFF('NTT 16-17'[Last Payment on],'NTT 16-17'[DueDate],DAY),1*DATEDIFF('NTT 16-17'[DueDate],'NTT 16-17'[Last Payment on],DAY))


1.PNG


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ITS VERY IMPORTANT FOR ME HELP ME AS SOON AS POSSIBLE.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.