cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Custom YTD and Month slicer measure

Hi all,

 

I am stuck in a situation. I want to show a YTD KPI number count with a custom FY which starts from June '21 to May '22. But this YTD should change as the user selects the respective month from the slicer.

 

For example: If the user selects June, it should show count till June '21, if the user selects September, then it should show June '21 to September '21 count etc.

 

For the custom YTD I've already created a measure which goes like - 

  YTD_Count = Calculate(Count('Table1'[UserID]), DatesYTD('Date'[Date], "05/31"))

 

Any suggestions on what I can do to solve this issue?

 

Thanks in advance!

1 ACCEPTED SOLUTION
AllisonKennedy
Super User
Super User

@Anonymous  This should work fine if you just add Date[Date] to the slicer. Can you provide screenshots or more info on exactly what's not working or where you're stuck?


Please @mention me in your reply if you want a response.

Check out my Olympics report with live stats - KUDOS much appreciated

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

View solution in original post

1 REPLY 1
AllisonKennedy
Super User
Super User

@Anonymous  This should work fine if you just add Date[Date] to the slicer. Can you provide screenshots or more info on exactly what's not working or where you're stuck?


Please @mention me in your reply if you want a response.

Check out my Olympics report with live stats - KUDOS much appreciated

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors