Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi there, I am looking to find common themes across multiple columns. I have changed my data as an example as the data I am using is personal. But in this example I have multiple flags and multiple colums of the colours in the flags.
Is there a way I can use an "if" function where if contains 'red' across any of the colour columns then 'Yes', if not then 'No' ?
Any help would be much appreciated.
Solved! Go to Solution.
you can unpivot tables in the PQ
then create a dim table that you can filter
create a measure
Proud to be a Super User!
do you mean if there is a red in the colour 1 column then Yes?
what's the expected output based on the sample data you provided?
Proud to be a Super User!
It's hard to explain because the actual data I am using is quite specific. But ultimatley It would say if red is in colour 1, colour 2, colour 3, or colour 4 then "Yes"
I would do this for various colours, then I would be able to determine how many flags contain red, how many flags contain blue etc.
The data I am using contains 3000+ rows of data
you can unpivot tables in the PQ
then create a dim table that you can filter
create a measure
Proud to be a Super User!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
108 | |
108 | |
92 | |
67 |
User | Count |
---|---|
161 | |
129 | |
129 | |
92 | |
91 |