Forum Discussion
Max Column not showing correctly
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
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.
2 Replies
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.
