Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
AndrewHam
Helper I
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 ?

 

AndrewHam_0-1672990690020.png

 

1 ACCEPTED SOLUTION
AndrewHam
Helper I
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.

View solution in original post

1 REPLY 1
AndrewHam
Helper I
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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.