Forum Discussion
Anonymous
3 years agoNot applicable
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 an...
amitchandak
3 years agoSuper User
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