how
1 TopicHow to FILTER virtual table
Hi Team, I need a caculated table with names of costumers, who purchased something in 2 monthes, from period So i made an example table I need somehow FILTER that virtual table so that only costumers who have "AmountM" = 2 remain Table 2 = CALCULATETABLE( SUMMARIZE(Orders, Orders[Customer ID], "AmountM", COUNT('Calendar'[MonthYear])), DATESBETWEEN('Calendar'[Date], "01.01.2015","01.09.2015"))Solved588Views0likes1Comment