Forum Discussion
parallel period dax
rashidanwar , Are you looking for QOQ , you can use time intelligence
QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date])))
Last QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date],-1,QUARTER)))
Power BI — Qtr on Qtr with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
https://www.youtube.com/watch?v=8-TlVx7P0A0
Thank you amitchandak for your quick response.
I don't want QOQ.
I mentioned Q1-2001 and Q2-2021 just to represent the time. I simply want to controle the numbers from date range filter. When I select a period from the date range filter, the table need to show the current numbers for that period and also the comparative numbers for that period.
customer salesperson sales_amount (period selected from date range) Sales_amount(comparative)
Hi, rashidanwar
Not fully sure what you want. Can you share a sample file for further research?
Best Regards,
Community Support Team _ Eason
