Titles in tables which are dates that change relative to filtered date

[BaldAccountant]

I am trying to create a  table that has the current quarter sales, the number of customers, and then the prior 4 quarters.  I want the titles for the prior quarters to display the quarter that the info is for.  Here is a screenshot that might help explain.

I have 2 tables, a date table and a table with dates, sales, and names.  I have a measure for each prior quarter for example

Quarter -1 = CALCULATE(sum(Data1[Sales]),DATEADD(Date1[Date],-1,QUARTER)).

I Now that I think about it, I should have put the data showing 2 years worth of data vs 1 year,  But say I was filtering for 2nd quarter 2022.  I would want quarter-1 to be 1st quarter 2022, quarter -2 to be 4ht quarter 2021, and quarter-3 to be 3rd quarter 2021.

Thanks in advance for any help

[amitchandak]

@BaldAccountant , That is what it should give as long as Slicer / visual is using quarter from Date table?

What is missing ?

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[BaldAccountant]

Yes I am suing a slicer by quarter

I will try to send a link to the file, but my dropbox links have not worked for peope in the past

https://www.dropbox.com/s/3rc2h47omfz0eje/Test%20Quarters.pbix?dl=0

I am not 100% sure what you mean by it should work.  I can make a table to show just the values by quarter, but I want to include other columns like I did with the count of names.

I created measures to get the prior quarter values and that worked, but the titles give the name of the measure.  I want the date of the prior quarters.

PS thank for spending your time answering peoples questions.  I have used a lot of your solutions for other people.