Forum Discussion

DagdasAlbag's avatar
DagdasAlbag
Icon for Helper I rankHelper I
4 years ago
Solved

rolling days (YTD)

Hello all, how do I get rolling days: Example today is 16.03.2022 - in the evaluation all values should be filtered by YTD - 16.03.2022 - 16.03.2021 - 16.03.2020    
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, DagdasAlbag ;

    Try to create a column.

    rolling = IF(MONTH([Date])<MONTH(TODAY()),1,IF(MONTH([Date])=MONTH(TODAY())&&DAY([Date])<=DAY(TODAY()),1,0))

    The final output is shown below:

    Or create a measure:

    rolling days = DATEDIFF(DATE(YEAR(TODAY()),1,1),TODAY(),DAY)

    The final output is shown below:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

AntonioHR's avatar
AntonioHR
Icon for Helper I rankHelper I
4 years ago

Hello DagdasAlbag, 

I think you dont need DATE(TODAY()), TODAY() already gives you date.

  • DagdasAlbag's avatar
    DagdasAlbag
    Icon for Helper I rankHelper I
    4 years ago
    it does not work
     
    Rollierende Tage =
    VAR ytddate = TODAY()
    RETURN
    IF(DimDatum[Datum] <= ytddate,1,0)