topic Re: Translation of Maxifs excel into DAX in DAX Commands and Tips

Translation of Maxifs excel into DAX

Anonymous — Mon, 04 Jul 2022 19:19:47 GMT

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!

Re: Translation of Maxifs excel into DAX

Nathaniel_C — Mon, 04 Jul 2022 20:26:16 GMT

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

Re: Translation of Maxifs excel into DAX

Nathaniel_C — Mon, 04 Jul 2022 20:27:37 GMT

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

Re: Translation of Maxifs excel into DAX

Anonymous — Mon, 04 Jul 2022 20:53:57 GMT

Thanks for the help!

Re: Translation of Maxifs excel into DAX

Nathaniel_C — Mon, 04 Jul 2022 21:12:08 GMT

Hi Anonymous ,

You are very welcome!

Nathaniel