Forum Discussion
parallel period dax
Hi everybody
I am posting here after due search and if somebody can guide me I would really appreciate.
I have a sales table and and a date table. Sales table contains varius dimensions and metrics.
Forexample: customer, salesperson, invoice_date, sales_amount etc
date table is actually a calendar that has relationship with the invoice_date in the sales table.
I want to have following slicers on top of the page
date range, cutsomer, sales person
Then I want to have a table containing customer and sales person fields and also the sales amount as selected from the date range and also the comparative sales amount of the exact parallel period.
Table looks like as follow, and please note that it's being controled by the filters mentioned above.
customer salesperson sales_amount (Q1-2021) Sales_amount(Q1-2020)
Thank you! so much.
Rashid Anwar
3 Replies
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-TlVx7P0A0Thank 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
