Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Custom column: Add text to data for different

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...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , 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")

  • negi007's avatar
    negi007
    5 years ago

    Anonymous 

     

    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's avatar
amitchandak
Super User
5 years ago

Anonymous , 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")