Another Day Another Query,
Sorry for all the Questions but just gone into a new job and using a lot of time intelligence that I haven’t had to use in the past.
I have a Measure Total Quantity and I want to Calculate the Current Week and each of the 5 Previous weeks. What does the Current Week measure look like?
Once I have the Current Week measure do I just have 5 other measures that use the DateAdd Function -1, -2 etc or is there another clever way?