Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
s_santalucia
Partner - Creator
Partner - Creator

Date selection both dimension

Hi guys,

I want to calculate a measure when both 2-dimensional values ​​are included on the selected dates.



for example: calculate the purchased when both the invoice and the order were made in September and August.



Give me help?


Thanks.

3 Replies
bbmmouha
Creator
Creator

it s not clear please give us more details

sum({<month = {'August','September'}> purchased}

s_santalucia
Partner - Creator
Partner - Creator
Author

it is not correct.



suppose I place an order in September and the bill is in October.

if I select the months of September I must have 0 
purchased because the bill is not September

bbmmouha
Creator
Creator

print screen or an exemple please

i can't help you like this