sum by different groups and date and plot value by different date column

[Anonymous]

Hi, I have a problem in Power Bi which is quite complex (for me). I use confidential data, so i replaced the data with simple data to show you my problem. So I have 2 different date column: when the products were sold ('S date') and when they were paid ('P date'). I have different shops where they were sold and different products that were sold. There are some cases when the company buy its own products. And we would like to adjust the value of transactions with the company's own purchases. The company's own purchases appear as negative values (for example last row in the sample is the company's own purchase and the first two rows are the ones that should be adjusted), and the company always buy their own products in shop 'A'. So I would like to summarize the value of transactions by shop, product, P date, but i want to show the values on the figures by S date.  Unfortunately S date is not always the same in the rows that should be adjusted and in the rows that are used for the adjustment, so the connection key between them is the P date, however on the figures S date should appear.   

shop	S date	P date	product	value of transaction
A	18-May-2019	23-May-2019	X	300
B	18-May-2019	23-May-2019	X	500
B	26-Apr-2019	1-May-2019	Z	400
A	16-Apr-2019	21-Apr-2019	Y	200
B	16-Apr-2019	21-Apr-2019	Z	300
A	6-Apr-2019	11-Apr-2019	Z	800
A	18-May-2019	23-May-2019	X	-800

So could you please help me with the dax functions that can be used for this grouped summary?
Thanks a lot, 
Domingo

[v-chuncz-msft]

@Anonymous ,

You may simply try Drill down in a visualization in Power BI.

[Anonymous]

Hi, thanks for your answer. If only the problem was that simple. 
I wanna aggregate the values daily by P date, but i wanna show them on the chart using a different date (S date). So i guess i have to sum the values by P date using a dax function. Because with the drill down function i cannot drill down by one date but show on the chart another date.