Forum Discussion
Creating a new measure
Hi, I am trying to find the max sum of TOA within the first, second and third quarter of the last 4 weeks of each month per quarter. For Quarter four I just need the max sum of TOA for the quarter...
You have not mentioned CONTAINSROW before. Please show your DAX query.
MAX Per QT1-3 =
CALCULATE(MAXX(VALUES(Reporting[Weekending_Date__c].[Date]), CALCULATE(SUM(Reporting[TOA__c]), DATESINPERIOD(Reporting[Weekending_Date__c].[Date], MAX(Reporting[Weekending_Date__c]), -28,DAY ), VALUE(Reporting[Weekending_Date__c].[Quarter] IN {1,2,3} ))))
I do not have CONTAINSROW in my formual so that is why im confused?