MINX() and MAXX() functions
In the DAX (Data Analysis Expressions) language, used mainly in Power BI, SQL Server Analysis Services (SSAS), and Power Pivot for Excel, the MINX and MAXX functions are aggregation functions that respectively calculate the minimum and maximum value of an expression evaluated on a specified data set. Let’s take a look at how these two […]