Power BI DAX equivalent of MINIFS in excel

[Shales]

Hi,

I only discovered the MINIFS function in Excel today, and instantly wondered if there was a Power BI DAX equivalent.

I have a quite basic excel formula of;

=MINIFS(A:A,B:B,B2)

Lets say A:A = Sub_ID & B:B = ID

I am trying to find the Min Sub_ID when there are more than 1 count of ID's

If there a DAX someone can help me with?

Thank you so much.

Gav

[themistoklis · Accepted solution]

@Shales

You can tty the following Measure:

MIN_SUBID = CALCULATE(MIN('Table'[Sub_ID ]), ALLEXCEPT('Table', 'Table'[ID]))

Output:

[themistoklis · Accepted solution]

@Shales

You can tty the following Measure:

MIN_SUBID = CALCULATE(MIN('Table'[Sub_ID ]), ALLEXCEPT('Table', 'Table'[ID]))

Output:

[Shales · Accepted solution]

As simple as that hey : ) I was massively over thinking it. I have tried to "Accept the Solution" but it keeps saying Authenticity failed. I'll keep trying. Thank you Gav