Max Column not showing correctly

[yaman123]

Hi all, 

I have a matrix table in a report and I have a MAX date column in the Rows section. But each time the report refreshes, it expands the column and shows the dates for the month instead of the max date.  So below should show as Min Date 01/09/2021 and Max Date should show as 30/09/2021. 

Is there a way to correct this? 

TIA

[v-chenwuz-msft · Accepted solution]

Hi @yaman123 

If you use max date as a row or column of a matrix table, it will not be calculated. If you want to do the calculation, then you should create a new measure and put it in the value.

Create a measure like this.

Max Date_Measure =
MAXX(
    FILTER( 'Table', [Min Date] = SELECTEDVALUE( 'Table'[Min Date] ) ),
    [Max Date]
)

If I misunderstood you , please let me know.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jppv20]

Hi @yaman123 ,

Could you provide some example data from your table?