Tryed to find an already posted solution, but didn't succeed.
I'm trying to make a calculation to my table that shows last season weekly sales. Its the value "LY WEEK" in below table that I can't seem to create a meassure for.
The booking week is taken from a booking date table.
Sales data from a Sales Table where cancel date as well is shown for cancelled sales. If for example one is booked in week 1, but cancelled in week 3, the sales value of both WEEK and ACK should be included in book week 1+2 and the removed again in week 3 as it is cancelled that week.
I tried with the following meassure, but I recieve an error: