MIN, MINA, MINX - DAX Guide

preview_player
Показать описание
MIN: Returns the smallest value in a column, or the smaller value between two scalar expressions.

MINA: Returns the smallest value in a column.

MINX: Returns the smallest value that results from evaluating an expression for each row of a table. Strings are compared according to alphabetical order.

This video is part of DAX Guide, the online guide to all the DAX functions, with links to related content and compatibility matrix with all the versions of Power BI, Azure Analysis Services (AAS), SQL Server Analysis Services (SSAS), SQL Server Data Tools (SSDT), and Power Pivot for Excel.


#dax #powerbi #ssas #tabular #analysisservices #powerpivot
Рекомендации по теме
Комментарии
Автор

Short and to the point. The example with SUMX and column on the fly is a good one - a powerful technique. 👍 Thanks!

mnowako
Автор

These videos are very helpful, thank you so much. Is there a performance hit to use the X version (MINX, SUMX, AVERAGEX) if they aren't required?

JoelShafron
Автор

[Min Alpha] = MIN("A", "B")

FredKaffenberger