Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

date difference calculation with positive and negative number

Hi All,   Currently i need to calculate 2 dates difference with Postive & negative numbers.   i need to have both positive and Negative numbers in calculation. when i use Datediff formula, i alwa...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous,

     

    To create a calculated column as below.

     

    datediff = var diff = DATEDIFF('Table1'[Start date],'Table1'[Current date],DAY)
var diff2 = DATEDIFF('Table1'[Current date],Table1[Start date],DAY)
return
IF(Table1[Start date]<='Table1'[Current date],diff,0-diff2)

     

    For more details, please check the pbix as attached.

     

    Regards,

    Frank

Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
7 years ago

try just subtracting them, e.g.

Table[Current date] - Table[Start date]

you may need to format it as a whole number, and possibly round if you have times included (they're represented as fractions), but other than that should work fine

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I have tried that, but that is not working.