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
@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.
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.
