Forum Discussion
Creating Measure based on Today's Date subtracting from another date
I need to create a new measure that takes Today's date and subtracts it to another date (column in a table) to get number of days. I can't figure out how to write the formula.
Hi , dw0120
Could you please tell me whether your problem has been solved?
If yes, you could accept the helpful answer as solution.For now, there is no content of description in the thread. If you still need help, please share more details to us.
In addition ,if you just want a measure ,you can try function datediff as below:
Measure = DATEDIFF(CALCULATE(MAX(Sheet1[Date])),TODAY(),DAY)Measure = DATEDIFF(SELECTEDVALUE(Sheet1[Date]),TODAY(),DAY)Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
dw0120 Try:
New Column = (TODAY() - [Date]) * 1.Hi , dw0120
Could you please tell me whether your problem has been solved?
If yes, you could accept the helpful answer as solution.For now, there is no content of description in the thread. If you still need help, please share more details to us.
In addition ,if you just want a measure ,you can try function datediff as below:
Measure = DATEDIFF(CALCULATE(MAX(Sheet1[Date])),TODAY(),DAY)Measure = DATEDIFF(SELECTEDVALUE(Sheet1[Date]),TODAY(),DAY)Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
