1 of 1 people found this helpful
Think this could be done by setting two parameters as date-formats and then filtering the measures through if-statements in calculations (if date = snapshot date, return sales).
Please see the attached workbook (i have added two parameters "Snapshot date 1 & 2" and two calculations "Sales on snapshot date 1 & 2").
My example is made on region, but as soon as you have the calculations in place - they will work across all dimensions.
Hope this will help you forward...
update: attached Packaged workbook (sorry it was a twb only on the first post)
Thank you Kasper,
That was really helpful, this work fantastically until I tried to bring in any additional detail from the 2 dates, (e.g. show the 2 sales dates as columns)
I tried to apply the same logic for selecting the dates but this then purely created multiple rows as it isn't an aggregate function.