Calculated column in date table to 1 if in the last 24 months including current month

[blestone111]

Hi Experts

I need a calculated column to add to the date table to show if the date including current month is in the last 24 months then 1 else 0. the relative date filter is not working on committed date, but works on date date. if that makes any sense.

[Anonymous · Accepted solution]

Hi @blestone111 ,

I create a table as you mentioned.

Then I create a new calculated column. Here is the DAX code.

Column =
IF (
    DATEDIFF ( 'Table'[Date], TODAY (), MONTH ) <= 24
        && DATEDIFF ( 'Table'[Date], TODAY (), MONTH ) >= 0,
    1,
    0
)

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.