Forum Discussion
Comparing week with pervious week
Hi, I have a measure as below which should return the sum of amount for the previous week, based on the User selecting the current week. I have my week index’s defined in my Date table. Not sure if ...
thanks so much for your help, UNfortunatly neither approach is working for me.
Using the Datesbetween I get blank results and when I use the reworked version with Crossjoin I get identical results for both weeks: really feels like what you propose should work - thanks again