parallel period dax

[rashidanwar]

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

[amitchandak]

@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

[rashidanwar]

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)

[v-easonf-msft]

Hi, @rashidanwar 

Not fully sure what you want. Can you share a sample file for further research?

Best Regards,
Community Support Team _ Eason