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)))
mickey64's avatar
mickey64
Super User
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)))
kivancc94's avatar
kivancc94
Helper I
3 years ago

Worked ! Thanks a lot.