Forum Discussion
Subtract Today() from a Column
Anonymous sorry missed a parenthesis
New Column Name = IF(Table[AY2 Column Name] <> "NA", FORMAT ( DATEDIFF ( TODAY(), Table[BB2 Column Name], DAY ), "General Number" ), "OPEN") ).✨ Follow us on LinkedIn and to our YouTube channel
Check my latest video on Filters and Sparklines https://youtu.be/wmwcX8HvNxc
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.
Anonymous sorry, just reverse the column in the datediff
DATEDIFF ( Table[BB2 Column Name], TODAY(), DAY )✨ Follow us on LinkedIn and to our YouTube channel
Check my latest video on Filters and Sparklines https://youtu.be/wmwcX8HvNxc
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.
=DATEDIFF( [Closed On], Today(), DAY )
Getting this error - Cannot convert value 'OPEN' of type Text to type Date.