Create table with DoD Data

[Anonymous]

Hello everyone, 

I need to create a PowerBI visualization in which I should be able to see the values of different measures for the current day and for the same day of the week before and have another column that shows the day-over-day change percentage.

My table should look something like this:

	09-08-23	02-08-23	DoD
Measure 1	0.5	0.9	80%
Measure 2	11128	11128	0%
Measure 3	500	1,000	100%

Where DoD = (Current Date Value / Same day of last Week Value) -1

Currently I'm not being able to put the date columns and the DoD column side by side.

Is this possible?

Thanks in advance

[amitchandak]

@Anonymous , You can measure like

This Day = SUM(Sales[Sales Amount])

7 behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-7,DAy))
diff =[This Day] - [Last Day]

Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...