My Measure = var thisMonth = MAX('YourTable'[MonthSeq]) return CALCULATE( SUM('YourTable'[order]), ALLEXCEPT('YourTable', 'YourTable'[Product]), 'YourTable'[MonthSeq] >= thisMonth - 2 && 'YourTable'[MonthSeq] < thisMonth ) but getting errror: The resultset of a query to external data source has exceeded the maximum allowed size of '1000000'. using direct query mode.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)