rolling days (YTD)

[DagdasAlbag]

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

[v-yalanwu-msft · Accepted solution]

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]

Hello @DagdasAlbag, 

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

[DagdasAlbag]

it does not work

Rollierende Tage =

VAR ytddate = TODAY()

RETURN

IF(DimDatum[Datum] <= ytddate,1,0)