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.
I was able to do this easily with two columns, but now I have three separate sources that I want to determine the different types of matching across the columns. I want to use the results as a slicer essentially so I can filter in my report.
Here is an example set of what i'm trying to accomplish:
Basically depending on the criteria it meets if its in one or more columns I want to give it a description like in my Preferred Output example above.
Thanks ahead of time for any and all help!
Solved! Go to Solution.
@suchomelb Try:
Column =
SWITCH( TRUE(),
[A] <> BLANK() && [B] <> BLANK() && [C] <> BLANK(), "In All",
[B] = BLANK() && [C] = BLANK(), "Not in B or C",
[A] = BLANK() && [B] = BLANK(), "Not in A or B",
[C] = BLANK(), "Not in C",
[A] = BLANK(), "Not in A",
BLANK()
)
@suchomelb Try:
Column =
SWITCH( TRUE(),
[A] <> BLANK() && [B] <> BLANK() && [C] <> BLANK(), "In All",
[B] = BLANK() && [C] = BLANK(), "Not in B or C",
[A] = BLANK() && [B] = BLANK(), "Not in A or B",
[C] = BLANK(), "Not in C",
[A] = BLANK(), "Not in A",
BLANK()
)
This worked perfect for me. I'm still trying to wrap my head around how it all works but i'm just glad there's people out there like you that do so I can learn it from somebody. I havn't used Power BI for more than six months or so and the DAX seems way more difficult to learn than excel formulas were. Thanks again!
You can use a custom column to compare multiple values. It doesn't have a gui to help out but the logic should be pretty simple to follow. Check out this post which has an example using dates.
Solved: Power query If submit date between start date and ... - Microsoft Power BI Community
User | Count |
---|---|
94 | |
86 | |
78 | |
72 | |
66 |
User | Count |
---|---|
115 | |
106 | |
85 | |
65 | |
64 |