Forum Discussion

DagdasAlbag's avatar
DagdasAlbag
Helper 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.

3 Replies

    • DagdasAlbag's avatar
      DagdasAlbag
      Helper I
      4 years ago
      it does not work
       
      Rollierende Tage =
      VAR ytddate = TODAY()
      RETURN
      IF(DimDatum[Datum] <= ytddate,1,0)
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    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.