Forum Discussion

DagdasAlbag's avatar
DagdasAlbag
Helper I
4 years ago
Solved

Calculated column

how can I turn rolling months into rolling days?
the formula refers to rolling months:
 
Rollierende Monate =
VAR ytdmonths = MONTH(TODAY())
RETURN
IF(Kalendertabelle[Monat_kurz] <= ytdmonths,1,0)
  • amitchandak's avatar
    amitchandak
    4 years ago

    DagdasAlbag , try like

     


    Rollierende Monate =
    VAR ytdmonths = format(TODAY(), "MMDD")
    RETURN
    IF(format(Kalendertabelle[Date], "MMDD") <= ytdmonths,1,0)

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    DagdasAlbag , try like

     


    Rollierende Monate =
    VAR ytdmonths = format(TODAY(), "MMDD")
    RETURN
    IF(format(Kalendertabelle[Date], "MMDD") <= ytdmonths,1,0)