Forum Discussion
AdministratorStatus date Calendar
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
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
3 Replies
- amitchandak
Super User
Syndicate_Admin , You can not use slicer value in a calculated table or calculated column
Syndicate_AdminHello, 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"
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
