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

[Thiyags]

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

[Satish_Kumar]

@Thiyags

[manderson]

@Satish_Kumar -

Have you checked this thread? https://community.powerbi.com/t5/Service/Days-between-two-dates-columns/m-p/7567#M3500 

Or this one: https://community.powerbi.com/t5/Desktop/calculate-number-of-days-between-2-dates/td-p/51213

[Satish_Kumar]

@Thiyags

its giving wrong answer.

[manderson]

Hi @Satish_Kumar,

What is the wrong answer? Please give more info.

[Satish_Kumar]

@manderson

its only subtracting the days

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

answer is -5 only which is wrong

[Satish_Kumar]

its only subtracting the days

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

answer is -5 only which is wrong

[Satish_Kumar]

[v-yuezhe-msft · 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))

Thanks,
Lydia Zhang

[Satish_Kumar]

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