Run Daily data table

Question

Hello community, I have data as belowDatePriceApproved Date Time6/12/202312.44446/12/2023 5:046/12/202312.26/12/2023 9:067/12/202311.98446/12/2023 7:108/12/202310.46/12/2023 5:10&nbsp;I want to show data in the table as below:DateDate+1Date+2PriceDate+1 PriceDate+2 Price6/12/20237/12/20238/12/202312.211.984410.4&nbsp;Can anyone please able to help me to run this through Mquery or DAX please?&nbsp;TIA&nbsp;

ahmedx · Accepted Answer

pls try this

Forum Discussion

Run Daily data table

1 Reply

Related content

Monthly sales budget data allocation to daily grain

Storage increasing daily

Creating a table for daily plan vs. actual data

SQDCP Daily Dashboard

Adding daily data to historical table

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

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