Forum Discussion

kivancc94's avatar
kivancc94
Helper I
3 years ago
Solved

Creating Calendar Column with Date Condition

Hi   I would be happy if you could help me. I have also used measure to solve that but failed. Problem : If today is the first day of current month , for example ( 01 August 2023 ) t...
Need Help
Show and Tell
Tips and Tricks
  • mickey64's avatar
    mickey64
    3 years ago
    I made a calendar table.
     
    Column = CALENDAR(
            IF(DAY(TODAY()) = 1,
                DATE(YEAR(TODAY()), MONTH(TODAY())-1, 1),
                DATE(YEAR(TODAY()), MONTH(TODAY()), 1)),
            IF(DAY(TODAY()) = 1, 
                EOMONTH(TODAY(),-1),
                EOMONTH(TODAY(),0)))
jdbuchanan71's avatar
jdbuchanan71
Super User
3 years ago

The CALENDAR function returns a table, so I don't think that is what you are wanting.  Is this what you are looking for?

 

Column =
VAR _Today = TODAY()
RETURN
    IF (
        DAY ( _Today ) = 1,
        EOMONTH ( _Today, -2 ) + 1 & " - " & EOMONTH ( _Today, -1 ),
        EOMONTH ( _Today, -1 ) + 1 & " - " & EOMONTH ( _Today, -0 )
    )

 

It's not really clear to me what is the exact string you are wanting to see in that colmn today, Aug 12th and what would you want to see when TODAY() = Sept 1st?

 

What do you want to see on the rows for dates 3 months ago?

 

  • kivancc94's avatar
    kivancc94
    Helper I
    3 years ago

    As an example.

    If today is 01.08.2023 ( first day of current month)
      I would like to have calendar table between 01.07.2023 - 31.07.2023 

    else ( today is <> 01.08.2023 )

    I would like to have calendar table between 01.08.2023 - 31.08.2023