Forum Discussion
Allow indirect filter using allexcept
Hi Everyone, Im trying to calculate the previous months sum of records but allow filtering on an attribulte (HomeRegion). I have a master table of HomeRegions joined to the enquiries table and wo...
Hi Anonymous,
This should do the trick
CN_New Enquiries in past Month 2 = if( max(DateMonthTable[YYYYMM]) > format( today(), "yyyyMM" ), 0, CALCULATE( sum(CN_Enquiries[Number Of Enquiries]), filter( ALLEXCEPT(CN_Enquiries,'Teams'[Master HomeRegion]), datediff( CN_Enquiries[EOM_EnquiryDate], max(DateMonthTable[End of Month]), MONTH) = 1 ) ))
It did the trick. Thanks so much!
Glad to Help