Hello!
I have global date filter, but need to calculate measure for the previus period of choosen (start date of filtered period is end date for previous period). Unfortunately, set analysis not work(
I have start_date, end_date variables of my Date. Also I have create a start_date_compare_period variable
start_date_compare_period=date(start_date-interval#(end_date-start_date,'DD'), 'DD.MM.YYYY')
My measure is
sum({<Type={'Demands'},
[Date]={'<$(start_date)>$(start_date_compare_period)'} >}
quantity*price)
This not working(