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.
Solved! Go to Solution.
Hi @StoryofData
You can write this
Result = IF([Col A] = "Subject" && ([Col B] = "Substantiated" || [Col B] = "Unsubstantiated" || [Col B] = "Insufficient Data"), [Col D]&"-"&[Col C])
But when you have multiple options to match for an OR condition you can also use the IN function which is a little neater
Result = IF([Col A] = "Subject" && ([Col B] IN {"Substantiated" , "Unsubstantiated" , "Insufficient Data"}), [Col D]&"-"&[Col C])
Regards
Phil
Proud to be a Super User!
Hi @StoryofData
You can write this
Result = IF([Col A] = "Subject" && ([Col B] = "Substantiated" || [Col B] = "Unsubstantiated" || [Col B] = "Insufficient Data"), [Col D]&"-"&[Col C])
But when you have multiple options to match for an OR condition you can also use the IN function which is a little neater
Result = IF([Col A] = "Subject" && ([Col B] IN {"Substantiated" , "Unsubstantiated" , "Insufficient Data"}), [Col D]&"-"&[Col C])
Regards
Phil
Proud to be a Super User!
Follow up question Philip, the syntax works fine if it's in table format, however when I try to do a distinct count on it, the number is uncorrect in my screen shot below, distinct count should 5
Thank you
Hi @StoryofData
Your formula is testing for 3 different values in [Column B] but it can't have 3 different values. Because you are using && this situation isn't possible.
If you use || then that would be possible for [Column B] to have one of those 3 values. So if you have used || and still aren't getting the results you expect I'd need to see your data and the result of the formula to understand what is going wrong.
Can you please supply some data so I can understand exactly what it is you are trying to achieve.
Regards
Phil
Proud to be a Super User!
Hey, thank you for helping me, my condition is:
Column A = Subject AND
Column B = Substantiated OR Unsubstantiated OR Insufficient Data then combine C and D columns
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |