Forum Discussion

inglexjc's avatar
inglexjc
Post Patron
3 years ago
Solved

Date count

I have a date in a table that I want to know how many days since that date.  I've tried Days Open = CALCULATE(COUNT('TR_FSP_5A'[Open Date]),'TR_FSP_5A'[Open Date] > DATE(TODAY())).   Example Date...
Need Help
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    Hi, 

     

    create a new calculated column with:

     

    Column = DATEDIFF('Table'[Open Date],TODAY(),DAY)
     
    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
DOLEARY85's avatar
DOLEARY85
Resident Rockstar
3 years ago

Hi, 

 

create a new calculated column with:

 

Column = DATEDIFF('Table'[Open Date],TODAY(),DAY)
 
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍