Power BI Blog: DAX Function Changes to MINX and MAXX
28 September 2023
Welcome back to this week’s edition of the Power BI blog series. This week, we look the DAX function changes to MINX and MAX.
Sometimes DAX decides on a change – and one has recently been announced. There is now an optional variant parameter to the MINX and MAXX DAX functions. These functions ignore text and Boolean values when there are variants or mixed data types, such as text and numerical. Now, with the new optional variant parameter set to TRUE, the functions will consider the text values.
Here is an example of a variant measure. In the table below, the variant measure is ordered in ascending order:
MINX and MAXX without the variant parameter set, or set to FALSE, will ignore text and Boolean data types.
MINX and MAXX with the variant parameter set to TRUE will now include text values. Boolean values are still ignored.
The default of the MINX and MAXX optional variant parameter is FALSE, so all existing DAX expressions using MINX and MAXX will not be impacted by this change. To allow text values to be included, you can update the DAX expression to include TRUE as the third parameter.
That's it for this week. In the meantime, please remember we offer training in Power BI which you can find out more about here. If you wish to catch up on past articles, you can find all of our past Power BI blogs here.