Past rolling 6 months starting from current month in Table

[learner03]

How can I get below output-

Summarising at customer level and showing 6 months quantity sold startig from current month.

Item History table
Item	Customer	Quantity	Date
A	Cus1	4	2/05/2021
A	Cus2	6	7/07/2021
b	Cus1	3	3/06/2021
b	Cus3	5	4/05/2021
b	Cus4	7	19/04/2021
c	Cus2	9	22/09/2021
c	Cus1	1	1/03/2021
c	Cus4	3	3/06/2021
D	Cus3	4	17/04/2021
Output	( Starting Current month)
Months-->	Sep-21	Aug-21	Jul-21	Jun-21	May-21	Apr-21
Customer
Cus1
Cus2
Cus3
Cus4

[Ashish_Mathur]

Hi,

You may refer to my solution here - Flex a Pivot Table to show data for x months ended a certain user defined month.

Hope this helps.

[learner03 · Accepted solution]

@Ashish_Mathur How can  I get this in Power BI desktop?

[Ashish_Mathur]

Keep the Excel file closed.  Open PowerBI Desktop and go to File > Import > Power Query, PowerPivot, Power View.

Now build your visual.