Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn 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!
User | Count |
---|---|
53 | |
35 | |
20 | |
16 | |
15 |
User | Count |
---|---|
94 | |
72 | |
30 | |
22 | |
16 |