Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear Friends,
i am trying to achieve the results by grouping the decision of Episode ID using some business logic, can anyone help me on this?
Please refer below image for data set and expectation with Logics. KIndly ask me for more questions.
Thanks,
Yuvi
Solved! Go to Solution.
I attempted using Power Query.
if Table.MatchesAllRows([Grouped], each [Decision] = "Approved") then "Approved" else if Table.MatchesAllRows([Grouped], each [Decision] = "Denied") then "Denied" else if Table.MatchesAllRows([Grouped], each [Decision] = "Partially denied") then "Partially denied" else if Table.MatchesAnyRows([Grouped], each [Decision] = "Pending") then "Pending" else "Partially denied"
Proud to be a Super User!
Sorry. Try COUNTROWS ( DecisionList ) = 1 instead.
Thanks much for the solution. It works as expected. Thanks a ton again 🙂
I attempted using Power Query.
if Table.MatchesAllRows([Grouped], each [Decision] = "Approved") then "Approved" else if Table.MatchesAllRows([Grouped], each [Decision] = "Denied") then "Denied" else if Table.MatchesAllRows([Grouped], each [Decision] = "Partially denied") then "Partially denied" else if Table.MatchesAnyRows([Grouped], each [Decision] = "Pending") then "Pending" else "Partially denied"
Proud to be a Super User!
Thanks Chris for the quick solutioning and help. This is one of the cool technique i learned from you power query:) i appreciate your support and help on this. Have a good day!
How about this?
Overall Decision =
VAR DecisionList =
CALCULATETABLE (
VALUES ( Table1[Decision] ),
ALLEXCEPT ( Table1, Table1[Episode ID] )
)
RETURN
IF (
HASONEVALUE ( DecisionList ),
DecisionList,
IF ( "Pending" IN DecisionList, "Pending", "Partially denied" )
)
Thanks Alex for your solutioning. I tried the code and got the error as "The HASONEVALUE function expects a column reference expression for argument '1', but a table expression was used.", can you please help me on that ? Screen shot below for your reference.
Sorry. Try COUNTROWS ( DecisionList ) = 1 instead.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |