Run Daily data table

[MrTechie]

Hello community, I have data as below

Date	Price	Approved Date Time
6/12/2023	12.4444	6/12/2023 5:04
6/12/2023	12.2	6/12/2023 9:06
7/12/2023	11.9844	6/12/2023 7:10
8/12/2023	10.4	6/12/2023 5:10

I want to show data in the table as below:

Date	Date+1	Date+2	Price	Date+1 Price	Date+2 Price
6/12/2023	7/12/2023	8/12/2023	12.2	11.9844	10.4

Can anyone please able to help me to run this through Mquery or DAX please?

TIA

[Ahmedx · Accepted solution]

pls try this