Hi I have a formula below that show when an item was first sent to stores.
I need to filter only results that are <4 weeks on the floor. But since it's a value field I cant filter it.
Can someone please help. Thanks
IN STORES XXX:=CALCULATE(MAX('TRANSFERS'[FIRST SENT TO STORES]),FILTER(ALL(dCalendar[DATES]),'dCalendar'[DATES]<=MAX('dCalendar'[DATES])))
I need to filter only results that are <4 weeks on the floor. But since it's a value field I cant filter it.
Can someone please help. Thanks
IN STORES XXX:=CALCULATE(MAX('TRANSFERS'[FIRST SENT TO STORES]),FILTER(ALL(dCalendar[DATES]),'dCalendar'[DATES]<=MAX('dCalendar'[DATES])))