Maxifs in DAX

PMF998 · ‎11-11-2020

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.

CNENFRNL · ‎11-11-2020

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.

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

Maxifs in DAX

Helpful resources

Power BI Monthly Update - April 2024