cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

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.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors