Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculated Column: DATEDIFF with filter - not working + getting negative numbers

Hi folks, I'm hoping someone can help me. I'm trying to create a calculated column to show the time elapsed, in days, between when a piece of documentation was created [Created Date], and TODAY(...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

I would just do this:

 

DRAFT_TIME = 
  IF
  (
    CONTAINS('COMBINED_Articles','COMBINED_Articles'[Status],"Draft"),
    ([Created Date] - TODAY()) * 1. ,
    BLANK()
  )
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks so much for the quick feedback Greg_Deckler  - after your reply I realied that what I'm actually trying to create is a calculated column, not a measure - I do apologise. I've editied the original post accordingly...

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      6 years ago

      I think that calculation should work in a column.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Maybe I'm misunderstanding the issue, and simply doing something wrong?