how to filter current year sales and the last year sales for the same quarter

[Ansu8371]

Hello,
If we have such data, how can we compare the sales for two years like current year and last year in power bi visual? For example if we choose Q3-2023, it should show the two years sales like current year (Q3-2023) and last year (Q3-2022) and vice versa, how can it be possible? Thank you.

Year	Qtr	QQ-YYYY	Sales
2021	Q1	Q1-2021	88
2021	Q2	Q2-2021	75
2021	Q3	Q3-2021	66
2021	Q4	Q4-2021	85
2022	Q1	Q1-2022	91
2022	Q2	Q2-2022	70
2022	Q3	Q3-2022	99
2022	Q4	Q4-2022	80
2023	Q1	Q1-2023	93
2023	Q2	Q2-2023	91
2023	Q3	Q3-2023	88
2023	Q4	Q4-2023	110
2024	Q1	Q1-2024	96
2024	Q2	Q2-2024	89
2024	Q3	Q3-2024	106
2024	Q4	Q4-2024	98

[adudani · Accepted solution]

hi @Ansu8371 ,

• I converted the fact table in the model to have a daily date field ( Dates are required for time intelligence)
• I added a date dimension.
• Created 2 measures, 1 for sales. 1 for sales LY using Dateadd.

please see the solution here: https://drive.google.com/file/d/1SwhwghnmfIr649fp8VoNuXuT_ZrXJ8l-/view?usp=drive_link