Date count

[inglexjc]

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 open 05-01-2002 answer should be (based on today 4-14-2023) should be 7,653 days.

[DOLEARY85 · Accepted solution]

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 👍