Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Status 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 Marc...
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
amitchandak
Super User
4 years ago

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

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    4 years ago

    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"