Forum Discussion
Question on the Max Date Result
Dear all,
I have a pretty simple table with a date column dated 01.01.2022 to 31.12.2023 as below. Under the report review, I apply the Date slicer and the range chosen is 01.01.2022 to 19.11.2022.
For the two measures I have created as below, they are considered the same and the only difference is illustrated in below. The XXX.[Date] is actually auto by the system when the measure is written. Can you please help me to understand why these 2 measures generate different Max Date outcome?
Table Table
Report View with a Date Slicer
Measure 1
Mesure 2
Hi kelvin-lkhca
MAX(Table_Date[Date]) returns the maximum date value from the Date column of the ‘Table_Date’ table, whereas MAX(Table_Date[Date].[Date]) returns the maximum date value from the Date hierarchy of the ‘Table_Date’ table.
The slicer only affects the date column, not the hierarchy of that date.
For more information about date hierarchies in Power BI, you can refer to this documentation:
Auto date/time in Power BI Desktop - Power BI | Microsoft Learn
If you want to turn off date hierarchies in Power BI, you can do so by following these steps:Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi kelvin-lkhca
MAX(Table_Date[Date]) returns the maximum date value from the Date column of the ‘Table_Date’ table, whereas MAX(Table_Date[Date].[Date]) returns the maximum date value from the Date hierarchy of the ‘Table_Date’ table.
The slicer only affects the date column, not the hierarchy of that date.
For more information about date hierarchies in Power BI, you can refer to this documentation:
Auto date/time in Power BI Desktop - Power BI | Microsoft Learn
If you want to turn off date hierarchies in Power BI, you can do so by following these steps:Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.