cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AndrewHam
Frequent Visitor

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 ?

 

AndrewHam_0-1672990690020.png

 

1 ACCEPTED SOLUTION
AndrewHam
Frequent Visitor

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.

View solution in original post

1 REPLY 1
AndrewHam
Frequent Visitor

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.

Helpful resources

Announcements
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors