Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello!
I'm brand new to Power BI. I'm trying to create a calculated column containing a filter for three other columns in the same data sheet using OR logic.
I want a calculated column showing me all changes that will need post implementation review. I want to name that column "PIR" and I want a Boolean result in that column
Change Type = "Emergency Change"
OR
Expedited = True
OR
Resulted in Outage = True
I've tried a number of configurations and tried to follow examples I have found in help forums. But I'm just not getting it.
This is what I have for starters:
Solved! Go to Solution.
@FreemanZ - Thank you SO much! That gets me much closer.
What is the significance of the TRUE, TRUE, FALSE at the end?
I like to understand why I am doing what I'm doing.
Apparently, since the 'Change Type' field is not boolean and the other two fields are, FILTER is giving me an error.
So, I am trying to make another calculated column called "Emergency" that returns "True" for any change where Change Type = "Emergency Change"
I have tried this:
hi @SarahHope
try like:
@FreemanZ I've got it!
Emergency = CONTAINSSTRING('Full SharePoint Export'[Change Type],"Emergency Change")
This works!
I also learned that the field for "Resulted in Outage" looked like True/False, but it wasn't. I changed it.
Everything works.
I'm still wondering what the TRUE, TRUE, FALSE) at the end of the statement you provided means.
That's not urgent, but I would like to know.
Also, I want to accept the solution with a caveat - Can I do that?
"This solution works as long as all the fields are True/False"
@FreemanZ - Thank you SO much! That gets me much closer.
What is the significance of the TRUE, TRUE, FALSE at the end?
I like to understand why I am doing what I'm doing.
Apparently, since the 'Change Type' field is not boolean and the other two fields are, FILTER is giving me an error.
So, I am trying to make another calculated column called "Emergency" that returns "True" for any change where Change Type = "Emergency Change"
I have tried this:
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |