Calculated Column for Previous Quarter Sales by Customer

[pwrbiadm]

Hello,

I have 2 input tables - Customer Details and Order Details. I have to calculate Previous Quarter Sales for a particular Customer which should not change based on Product or Date filters. Please help me with calculating values of V, W, X, Y & Z. Thanks!

Input Table
Customer Name	Prev Qtr Sales
A	V
B	W
C	X
D	Y
E	Z

Input Table
Customer Name	Order Date	Product	Sales
A	1/29/2019	G	$     990
B	1/23/2019	H	$     195
C	1/23/2019	I	$     100
D	1/23/2019	G	$     200
E	1/23/2019	H	$     495
A	1/23/2019	I	$     450
B	1/16/2019	G	$     195
C	1/16/2019	H	$     495
D	1/16/2019	I	$     495
E	1/16/2019	G	$     150
A	1/16/2019	H	$     450
B	1/9/2019	I	$     300
C	1/9/2019	G	$     180
D	1/9/2019	H	$     495
E	1/9/2019	I	$     195
A	1/4/2019	G	$     990
B	12/19/2018	H	$     150
C	12/20/2018	I	$     195
D	12/19/2018	G	$     990
E	12/19/2018	H	$     495
A	12/7/2018	I	$     990
B	11/29/2018	G	$     495
C	11/29/2018	H	$     495
D	11/20/2018	I	$     990
E	11/12/2018	G	$     990
A	11/7/2018	H	$     990
B	11/7/2018	I	$     150
C	10/29/2018	G	$     150
D	10/29/2018	H	$     495
E	10/22/2018	I	$     495
A	10/22/2018	G	$     495
B	10/18/2018	H	$     495
C	10/18/2018	I	$     450
D	10/5/2018	G	$     600
E	9/25/2018	H	$     300
A	10/5/2018	I	$     495
B	10/5/2018	G	$     450
C	10/5/2018	H	$     300
D	10/5/2018	I	$     300
E	9/20/2018	G	$     300
A	9/19/2018	H	$     600
B	9/25/2018	I	$     990
C	9/25/2018	G	$     300
D	9/20/2018	H	$     990
E	9/20/2018	I	$     450
A	9/14/2018	G	$     450
B	9/11/2018	H	$     990
C	9/11/2018	I	$     495
D	9/11/2018	G	$     150
E	8/27/2018	H	$     450
A	8/27/2018	I	$  1,485
B	8/21/2018	G	$     225
C	8/16/2018	H	$     300
D	8/10/2018	I	$  1,485
E	8/10/2018	G	$     150
A	8/10/2018	H	$     150
B	8/2/2018	I	$     495
C	8/2/2018	G	$     495
D	8/2/2018	H	$     450
E	7/17/2018	I	$     990
A	7/17/2018	G	$     150
B	7/17/2018	H	$     272
C	7/3/2018	I	$     150
D	7/2/2018	G	$     990
E	7/2/2018	H	$     105
A	7/2/2018	I	$     272
B	6/10/2018	G	$     225
C	5/22/2018	H	$     225
D	6/10/2018	I	$     990
E	6/10/2018	G	$     495
A	6/10/2018	H	$     272
B	5/31/2018	I	$     495
C	5/31/2018	G	$     105
D	5/31/2018	H	$        30
E	5/31/2018	I	$     495
A	5/22/2018	G	$     272
B	5/25/2018	H	$     150
C	5/22/2018	I	$     210
D	5/22/2018	G	$     495
E	5/22/2018	H	$     225
A	5/22/2018	I	$     300
B	5/8/2018	G	$     225
C	5/13/2018	H	$     272
D	5/8/2018	I	$     272
E	5/3/2018	G	$     544
A	5/13/2018	H	$     990
B	5/13/2018	I	$     495
C	5/3/2018	G	$     210
D	5/3/2018	H	$        83
E	5/3/2018	I	$        83
A	5/3/2018	G	$     165
B	5/3/2018	H	$     165
C	5/3/2018	I	$        50
D	5/3/2018	G	$        25
E	5/3/2018	H	$        75
A	4/24/2018	I	$     495
B	4/24/2018	G	$     150
C	4/3/2018	H	$     544
D	4/3/2018	I	$     105
E	4/3/2018	G	$     990
A	4/3/2018	H	$     495
B	4/3/2018	I	$     150
C	3/6/2018	G	$     990
D	3/6/2018	H	$     495
E	3/6/2018	I	$     150
A	2/22/2018	G	$     150
B	2/22/2018	H	$     300
C	2/16/2018	I	$     495
D	2/16/2018	G	$     544
E	2/16/2018	H	$     544
A	2/9/2018	I	$     990
B	2/9/2018	G	$     150
C	1/30/2018	H	$     495
D	1/30/2018	I	$     150
E	1/30/2018	G	$     150
A	1/30/2018	H	$     272
B	1/30/2018	I	$     272
C	11/23/2017	G	$     150
D	11/15/2017	H	$     495
E	11/6/2017	I	$     150
A	10/5/2017	G	$     150

Output Table
Customer Name	Product	Prev Qtr Sales
A	G	V
B	H	W
C	I	X
D	G	Y
E	H	Z
A	I	V
B	G	W
C	H	X
D	I	Y
E	G	Z
A	H	V
B	I	W
C	G	X
D	H	Y
E	I	Z

[v-chuncz-msft · Accepted solution]

@pwrbiadm,

Try using CALCULATE Function to change the context.

• https://community.powerbi.com/t5/Desktop/Year-on-year-for-previous-reporting-period/m-p/326661#M1457...
• https://www.sqlbi.com/articles/filter-arguments-in-calculate/