Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |