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.
Hello,
I would like to know if there is any way to know if the same value can be found on the same line across 4 different columns.
It doesn't matter what the value is (it is only going to be numbers) and in which column it is, as long as this value is present at least twice (example below). I couldn't find any formula that does the job.
And is it a lot more complicate to return the value as the example below?
Thank you so much in advance for taking the time to help me, I appreciate it !
Greetings,
Seb
Solved! Go to Solution.
Hi @Seabastein ,
You could try this:-
Column =
SWITCH(TRUE(),
('Table (3)'[Column1] = 'Table (3)'[Column2] || 'Table (3)'[Column1] = 'Table (3)'[Column3] || 'Table (3)'[Column1] = 'Table (3)'[Column4]),'Table (3)'[Column1],
('Table (3)'[Column2] = 'Table (3)'[Column4]) || ('Table (3)'[Column2] = 'Table (3)'[Column3]),'Table (3)'[Column2],
('Table (3)'[Column3] = 'Table (3)'[Column4]),'Table (3)'[Column3])
Output:-
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Thank you so much Samarth, it works well
Hi @Seabastein ,
You could try this:-
Column =
SWITCH(TRUE(),
('Table (3)'[Column1] = 'Table (3)'[Column2] || 'Table (3)'[Column1] = 'Table (3)'[Column3] || 'Table (3)'[Column1] = 'Table (3)'[Column4]),'Table (3)'[Column1],
('Table (3)'[Column2] = 'Table (3)'[Column4]) || ('Table (3)'[Column2] = 'Table (3)'[Column3]),'Table (3)'[Column2],
('Table (3)'[Column3] = 'Table (3)'[Column4]),'Table (3)'[Column3])
Output:-
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |