Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
DagdasAlbag
Helper I
Helper I

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

 

DagdasAlbag_0-1647433594204.png

 

1 ACCEPTED SOLUTION
v-yalanwu-msft
Community Support
Community Support

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:

vyalanwumsft_0-1647841606962.png

Or create a measure:

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

The final output is shown below:

vyalanwumsft_1-1647841643799.png


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.

View solution in original post

3 REPLIES 3
v-yalanwu-msft
Community Support
Community Support

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:

vyalanwumsft_0-1647841606962.png

Or create a measure:

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

The final output is shown below:

vyalanwumsft_1-1647841643799.png


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
Helper I
Helper I

Hello @DagdasAlbag

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

it does not work
 
Rollierende Tage =
VAR ytddate = TODAY()
RETURN
IF(DimDatum[Datum] <= ytddate,1,0)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.