Translation of Maxifs excel into DAX

[Anonymous]

So I have a table that looks like this in Power Bi... without the "Max Stage Value by Epic" column

This last column I am able to get the value by using the maxifs formula in Excel...
How can I get this same result in Power Bi?
Thanks for the help!

[Nathaniel_C · Accepted solution]

Hi @Anonymous 
Please try this: 

Max Stage Value = 

Var _Epic = Max(MaxTable[Epic])

var _calc = CALCULATE(MAX(MaxTable[Stage Value]),FILTER(All(MaxTable),MaxTable[Epic] = _Epic))

return _calc

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[Nathaniel_C]

Hi @Anonymous ,

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[Anonymous]

Thanks for the help!

[Nathaniel_C]

Hi @Anonymous ,

You are very welcome!

Nathaniel