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