return specific row of data between two dates

Question

Hello!&nbsp;I have the following data of where I'd like to return only the row with the "max" file end date on the ADHdate (so I can calculate the total in/total scheduled number for each max file end date and get a MTD average)This will return the max file end date of all the files where the data is being retrieved from:CALCULATE(MAXX(&nbsp; &nbsp; &nbsp; &nbsp; SUMMARIZE(&nbsp; &nbsp; &nbsp; &nbsp; ALLSELECTED(Summary),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (Summary[Index]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "MAX", MAX(Summary[FileEndDate])),[MAX]),&nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VALUES(Summary),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Summary[Index]=MAX(Summary[Index])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; Summary[ADHDate]=MAX(Summary[ADHDate])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; Summary[FileEndDate]=MAX(Summary[FileEndDate])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; )But I haven't been able to narrow down the row.&nbsp; All data is in the same table.Thank you!

parry2k · Accepted Answer

MDonovan&nbsp;try this measure:
&nbsp;
Max End Date = 
CALCULATE ( MAX ( 'Table'[File End Date] ),
    INDEX (
        1,
        SUMMARIZE ( ALLSELECTED ( 'Table' ), 'Table'[ADH Date], 'Table'[File End Date] ),
        ORDERBY ( 'Table'[File End Date], DESC ),
        PARTITIONBY ( 'Table'[ADH Date] )
    )
)
&nbsp;
Check new WINDOW functions Video playlist on my channel here&nbsp;https://www.youtube.com/playlist?list=PLiYSIjh4cEx0BDzmo48YIPzw_dIC0Kd95

Forum Discussion

return specific row of data between two dates

2 Replies

Related content

Return "Specific value" from table 1, if not found, return value from table 2

Specific matrix

Using two conditions to return a specific value

Return only rows with max value from specific column

Measure returning incorrect value