How to show a 1 instead of 0 on a DATEDIFF calculated column

[SandeA]

Hello! I haven't used Power BI in over a year and now trying to remember everything (its not easy!!) I created a calculated column to show the number of days between two dates:

Datediff = DATEDIFF('W9 Log'[Date Received in AP],'W9 Log'[ENTERED/ REVISION DATE],DAY)

Many instances have the same date in both columns so the result of the DATEDIFF is 0. Is there any way to show this as a 1 instead of a 0? 

Thank you in advance!

Sande

[Anonymous]

[Datediff Adjusted] =

var Datediff = <your formula from above here>

var DatediffAdjusted = if( Datediff = 0, 1, Datediff )

return DatediffAdjusted

or, if you know that Datediff is always >= 0,

[Datediff Adjusted] =

var Datediff = <your formula from above here>

return max( Datediff, 1 )

[VijayP · Accepted solution]

@SandeA  Same day means there is no difference hence it gives 0. 
IF(  above formula =0, above formula+1, above formula) use this to get 1 instead of 0

[Anonymous]

I'm trying to modify my function to show 1 instead of 0. Here is what I have. Please help.

Days Open = DATEDIFF('Master Log'[Date Opened],'Master Log'[Date Closed],DAY)

IF DATEDIFF >= 0,Day + 1

[Datediff Adjusted] =

var Datediff = DATEDIFF('Master Log'[Date Opened],'Master Log'[Date Closed],DAY)

var DatediffAdjusted = if( Datediff = 0, 1, Datediff )

return DatediffAdjusted

[SandeA]

Thank you @VijayP ! I knew it was an easy solution but couldn't wrap my head around it!