Status date Calendar

[Syndicate_Admin]

Hi all, I appreciate your help with the following

I need to create in my calendar table a column that indicates a status, the status depends on the date I have selected, for example if I select March that in the new coluna I see a status (TAM) from the aultimos 12 months to back.

This is my calendar table:

and I need something like this to be

[Anonymous · Accepted solution]

Hi @Syndicate_Admin ,

I created some data:

DATE(2021,1,1) -- DATE(2024,12,31)

Here are the steps you can follow：

1. Create calculated column.

Column =
IF(
    'Table'[Date]>EOMONTH(TODAY(),0)&&'Table'[Date]<=EOMONTH(TODAY(),+12),"TAM",BLANK())

2. Result:

Best Regards,

Liu Yang

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

[amitchandak]

@Syndicate_Admin , You can not use slicer value in a calculated table or calculated column

[Syndicate_Admin]

Hello, maybe I do not explain well, what I am needing is in a new column to create a state depending on the date, for example that if I am in the month of January, from January I put a state "True" 12 months for back and the rest of the dates "False"