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.
Hi there I have a series of custom columns example:
Concept (result is either pass fail or query)
Initiative (result is either pass fail or query)
Project (result is either pass fail or query)
Brief (result is either pass fail or query)
I need to then write a formula that tells me the following:
Overall Result = if any result of the 4 comes back a fail - its fail, if any result comes back a query - its query else Pass.
can you please help me? what is the best option for this formula?
thanks
🙂
Solved! Go to Solution.
Hi @Nikki ,
Create a Calculated Column
Status =
SWITCH (
TRUE (),
'Table'[Concept] = "Fail"
|| 'Table'[Initiative] = "Fail"
|| 'Table'[Project] = "Fail"
|| 'Table'[Brief] = "Fail", "Fail",
'Table'[Concept] = "Query"
|| 'Table'[Initiative] = "Query"
|| 'Table'[Project] = "Query"
|| 'Table'[Brief] = "Query", "Query",
"Pass"
)
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Hi @Nikki ,
Create a Calculated Column
Status =
SWITCH (
TRUE (),
'Table'[Concept] = "Fail"
|| 'Table'[Initiative] = "Fail"
|| 'Table'[Project] = "Fail"
|| 'Table'[Brief] = "Fail", "Fail",
'Table'[Concept] = "Query"
|| 'Table'[Initiative] = "Query"
|| 'Table'[Project] = "Query"
|| 'Table'[Brief] = "Query", "Query",
"Pass"
)
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Hi Again
my formula worked:
Maybe try something like this:
Status =
VAR FinalString =
CONCATENATEX (
FILTER ( Nikki, Nikki[Num] = EARLIER ( [Num] ) ),
[Concept] & [Initiative] & [Project] & [Brief]
)
VAR LowerString =
LOWER ( FinalString )
VAR PassIncluded =
SEARCH ( "pass", LowerString, 1, 0 )
VAR QueryIncluded =
SEARCH ( "query", LowerString, 1, 0 )
VAR Result =
SWITCH ( TRUE (), QueryIncluded > 0, "Query", PassIncluded > 0, "Pass", "Fail" )
RETURN
Result
thanks so much !!
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |