Last 12 Months of Data

[PavBid]

Hello,

In my Sales report, I need to show last 12 months of data.

Data is refreshed at the start of each month and the last months data is added (e.g., in early June, we will add May data).  

How do i automatically add the new month (May in this case) in the sales bar chart and remove May 2022 data? 

I am trying a measure Last 12 Months = EOMONTH(Today(), -12) - have not figured out how to do a comparison to the date in the date table.  

Also, I do have a date slicer, in case the user wants to see than 12 or more than 12 months.

Appreciate your suggestions!

Thanks,

Pav

[PavBid]

Thanks Wilson.  

But that does not let the user select less or more months from a month slicer.

[Wilson_]

Hello PavBid,

You can accomplish this from the filter tab; simply add a relative date filter for the last twelve months.

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)