Translate MAXIFS from Excel into DAX

[AndrewHam]

hi SuperUsers,

I read a number of post regarding the solution to translate MAXIFS from Excel into DAX but I'm not able to make it work.

Here is a sample of the table i have.

I am trying to find out for each Order-Line (most left column), which month # has not been invoiced.

If I am writing in Excel, I will be able to find out by using the formula below.

MINIFS(Month#,Order-Line Column A:A = Order-Line A2, Today>Contract Month Column K:K,0)

Can someone advise me , how to convert this to DAX ?

[AndrewHam · Accepted solution]

hi 

Managed to finally solve the issue with this formula

CALCULATE(MAX('[Month #]),FILTER('TableA','TableA'[Recognize Revenue]>0 && 'TableA'[Order-Line]=EARLIER('TableA'[Order-Line]))).

Find this solution is easlier to apply and understand.