MINA

Returns the smallest value in a column, treating TRUE as 1 and FALSE as 0.

What is the MINA Function?

The MINA function in DAX acts like a dedicated detective, on the lookout for the smallest value in your dataset while cleverly interpreting boolean values—counting TRUE as 1 and FALSE as 0. Whether you’re analyzing scores, sales, or any numerical data, MINA helps you uncover those hidden low points!

Example 1: Plant Growth Status

Imagine you’re tracking whether plants have sprouted in your garden. Here’s how your data might look:

To find the minimum growth status, treating TRUE as 1 and FALSE as 0, you would use the MINA function like this:

Min Growth Status = MINA(PlantGrowth[Sprouted])

Total Minimum Growth Calculation:

• Sunflower: 1 (TRUE, counted)
• Rose: 0 (FALSE, counted)
• Tulip: 1 (TRUE, counted)
• Daisy: 0 (FALSE, counted)
• Orchid: 0 (FALSE, counted)

So, what’s the lowest growth status? The minimum value is 0 from the Rose, Daisy, and Orchid! 🌱🌼

Example 2: Sensor Status Readings

Now, let’s analyze readings from a temperature sensor that indicates whether the temperature is within the desired range. Here’s your sensor data:

To find the minimum status while considering only TRUE/FALSE values, you would use:

Min Sensor Status = MINA(SensorReadings[Status])

Total Minimum Status Calculation:

• Living Room: 1 (TRUE, counted)
• Kitchen: 0 (FALSE, counted)
• Bedroom: 0 (FALSE, counted)
• Bathroom: 1 (TRUE, counted)
• Garage: 0 (FALSE, counted)

So, what’s the lowest sensor status? The minimum value is 0 from the Kitchen, Bedroom, and Garage! 📉📊

 Conclusion: Dig Deep with MINA!

The MINA function in DAX is your essential tool for finding the smallest values in your datasets, even when Boolean values are involved. Whether you’re evaluating sales performance or customer feedback, MINA helps you spotlight those unexpected lows!
So, let’s start digging deep and uncovering those minimum values with the MINA function! 🔍✨