cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PMF998
Regular Visitor

Maxifs in DAX

In Excel I can run the formula

=maxifs(Invoice Date, ID1, ID1, ID2, ID2)

Returning the latest Invoice Date for each unique instance of both ID1 and ID2.

What is the equivalent formula in DAX?

Many thanks.

1 REPLY 1
CNENFRNL
Super User III
Super User III

Hi, @PMF998 , you're on the right track, DAX is born for such statisitcal jobs. In your senario, you even don't bother to call any functions, but just a matter of drag-n-drop within a matrix visualization.

Untitled.png

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors