Forum Discussion

Justas4478's avatar
Justas4478
Icon for Post Prodigy rankPost Prodigy
4 years ago

Limiting data from specific filtered date for target

Hello, I have this measure. Model stores Sales Forum Average = CALCULATE (Averagex(Values('Store'[Store Number]) , [Sales Value LFL]),FILTER ( 'Store','Store'[Store Number] IN {"0716","0711"...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Justas4478 , Try like

 

Model stores Sales Forum Average = CALCULATE (Averagex(Values('Store'[Store Number]) , [Sales Value LFL]),FILTER (
'Store',('Store'[Store Number] IN {"0716"} && [Sales Value LFL] > date(2022,5,31) ) || 'Store'[Store Number] IN {"0711"}))

Justas4478's avatar
Justas4478
Icon for Post Prodigy rankPost Prodigy
4 years ago

amitchandak It looks to be working but I dont have means to check numbers. I will reply back once I check numbers next week. Thanks.