Power BI Blog: DAX Function Changes to MINX and MAXX

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.