A
C
- CALCULATE
- CALCULATETABLE
- CALENDAR
- CALENDARAUTO
- CEILING
- CHISQ.DIST
- CHISQ.DIST.RT
- CHISQ.INV
- CHISQ.INV.RT
- CLOSINGBALANCEMONTH
- CLOSINGBALANCEQUARTER
- CLOSINGBALANCEYEAR
- COALESCE
- COLUMNSTATISTICS
- COMBIN
- COMBINA
- COMBINEVALUES
- CONCATENATE
- CONCATENATEX
- CONFIDENCE.NORM
- CONFIDENCE.T
- CONTAINS
- CONTAINSROW
- CONTAINSSTRING
- CONTAINSSTRINGEXACT
- CONVERT
- COS
- COSH
- COT
- COTH
- COUNT
- COUNTA
- COUNTAX
- COUNTBLANK
- COUNTROWS
- COUNTX
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- CROSSFILTER
- CROSSJOIN
- CUMIPMT
- CUMPRINC
- CURRENCY
- CURRENTGROUP
- CUSTOMDATA
D
E
I
N
O
P
R
S
- SAMEPERIODLASTYEAR
- SAMPLE
- SEARCH
- SECOND
- SELECTCOLUMNS
- SELECTEDMEASURE
- SELECTEDMEASUREFORMATSTRING
- SELECTEDMEASURENAME
- SELECTEDVALUE
- SIGN
- SIN
- SINH
- SLN
- SQRT
- SQRTPI
- STARTOFMONTH
- STARTOFQUARTER
- STARTOFYEAR
- STDEVX.P
- STDEVX.S
- STDEV.P
- STDEV.S
- SUBSTITUTE
- SUBSTITUTEWITHINDEX
- SUM
- SUMMARIZE
- SUMMARIZECOLUMNS
- SUMX
- SWITCH
- SYD
T
U
What is the MINA Function?
The MINA function in Power BI is used to find the minimum value in a column or set of values. It is similar to the MIN function, but it has the added ability to work with text and other non-numeric values. This means that you can use the MINA function to find the minimum value in a column that contains a mix of numbers and text.
Syntax of the MINA Function
The syntax for the MINA function in Power BI is as follows:
MINA(❰column❱)
The ❰column❱ parameter is the name of the column or set of values that you want to find the minimum value for. You can also use the MINA function with multiple columns by separating them with a comma.
Example of Using the MINA Function
Let's say that you have a dataset that contains information about the sales of different products. You want to find the minimum sales for each product category. You can use the MINA function to do this.
To use the MINA function, you would first need to create a new measure. To create a new measure, go to the "Modeling" tab in Power BI and click on "New Measure".
In the formula bar, you would then enter the following formula:
Min Sales = MINA(Sales[Sales Amount])
In this example, "Sales" is the name of the table that contains the sales data and "Sales Amount" is the name of the column that contains the sales amounts. "Min Sales" is the name of the new measure that you are creating.
Once you have created the new measure, you can add it to a visual such as a table or a chart. This will display the minimum sales for each product category.
In summary, the MINA function is a powerful tool that can be used to find the minimum value in a column or set of values. It is particularly useful when working with columns that contain a mix of text and numbers. By using the MINA function in Power BI, you can quickly and easily find the minimum value for a given column or set of values. So, if you're working with Power BI, make sure to add the MINA function to your list of go-to functions.