Forum Discussion
Create table with DoD Data
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
1 Reply
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-5c3243d1f9
