Forum Discussion
Solved
Filter dates
Hello, I have a table of warehouse content, with "Last Transaction Date" column. I want to add column that gives "1" for dates from more than 24 months ago and "0" for dates in the last 24 months. ...
Hi,
add a calculated column with:
Column = IF(DATEDIFF('Table'[Last Trans.],TODAY(),MONTH)>24,1,0)If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi,
add a calculated column with:
Column = IF(DATEDIFF('Table'[Last Trans.],TODAY(),MONTH)>24,1,0)
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍