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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.