Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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
Proud to be a Super User!
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
Proud to be a Super User!
Thanks for the help!
Hi @Anonymous ,
You are very welcome!
Nathaniel
Proud to be a Super User!
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
Proud to be a Super User!