How to display last N months using Year Number slicer?

[Anonymous]

For example, If I click on 2017 year slicer, it has to show the previous N months data

[amitchandak · Accepted solution]

@swathijalakam28, see this -https://www.youtube.com/watch?v=duMSovyosXE

This for a date, but in the table create Year and use the year segmentation that will work

[Ashish_Mathur]

Hi,

See if my solution here helps - Flex a Pivot Table to show data for x months ended a certain user defined month.

[v-diye-msft · Accepted solution]

Hello @swathijalakam28

Please let me know if you want to get the following results:

Pbix joined.

[Syndicate_Admin]

Thanks a lot! It served me, it was just what I was looking for.

[harshnathani]

Hi @Anonymous ,

You can Refer to this video

https://www.youtube.com/watch?v=0enQCIWCSUE

Last N Weeks Comparisons (DAX Tutorial) (Last 3 weeks, Last 8 weeks,... Last N weeks)

Regards,

Harsh Nathani

[Fowmy]

@Anonymous 

Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?

_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn

[amitchandak · Accepted solution]

@swathijalakam28, see this -https://www.youtube.com/watch?v=duMSovyosXE

This for a date, but in the table create Year and use the year segmentation that will work