cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper I

## Translate MAXIFS from Excel into DAX

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 ?

1 ACCEPTED SOLUTION
Helper I

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.
Helper I

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.