Custom column: Add text to data for different

[koray]

Hello,

I have a column that calculates the date data coming from Excel according to today.

Kalan Gün = DATEDIFF(Liste[Bir Sonraki Validasyon Tarihi],TODAY(),DAY)

If the data in this column starts with "-" then "Days Left", if it doesn't starts with "-", I want to bring "Days Passed" text.

Like this:

Thank you for help.

[amitchandak · Accepted solution]

@koray , Try a new column like

Kalan Gün =
var _1 = DATEDIFF(Liste[Bir Sonraki Validasyon Tarihi],TODAY(),DAY)
return
if(_1 <0, _1 & " Days Left" , _1 & " Days Passed")

[koray]

Thank you both for your help.

[negi007 · Accepted solution]

@koray 

you can create your column like below

Column=

var diff = DATEDIFF('Date'[Date].[Date],TODAY()-50,DAY)

return

if (diff<0,diff&"-Days Left",diff&" days Passed")

let me know if it works for you or not. thanks

[amitchandak · Accepted solution]

@koray , Try a new column like

Kalan Gün =
var _1 = DATEDIFF(Liste[Bir Sonraki Validasyon Tarihi],TODAY(),DAY)
return
if(_1 <0, _1 & " Days Left" , _1 & " Days Passed")