Hi,
I only discovered the MINIFS function in Excel today, and instantly wondered if there was a 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
I only discovered the MINIFS function in Excel today, and instantly wondered if there was a 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