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 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.

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

3 Replies

  • negi007's avatar
    negi007
    Community Champion
    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")

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you both for your help.