Forum Discussion
Difference between previous week and this week data
Hello, I have data as follows Date Sales Oct 4 - 36 Oct 11 - 30 Oct 18 - 25 Oct 25 - 20 I need the difference between this week and previous week data i.e Oct 25 - Oct 18 20 ...
Hi,
Try this
=[Sales]-CALCULATE([Sales],FILTER(Calendar,MAX(Calendar[Table])-7)
I have assumed that the dates in your visual have been dragged from the Calendar Table. There should be a relatiosnhip between the Date column of your source data table and the date column of your Calendar table.
Hope this helps.
The date is a column from database
Hi ApurvaKhatri,
Is it me that you are replying to? If my solution is not working, please share the link from where i can download your file.