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 have created a calculated table as follows and I would like to create a calculated column called "Repeated" doing the following:
ID | Col1 | Col2 | Col3 | Col4 | Repeated |
AAA | 1 | ||||
BBB | 1 | 2 | Yes | ||
CCC | 3 | 5 | Yes | ||
DDD | 4 | ||||
EEE | 3 | 6 | Yes | ||
FFF | 2 | 5 | 1 | Yes |
[Repeated] would be a calculated column that if two or more columns contains a value then it returns "Yes".
All rows have value, but only want to get where rows has values in two or more columns.
The way I was doing it was using IF:
But I did when have 3 columns, now I have 4 and I can have more in the future, so I'm asking if you know a better way and simpler way to get that goal.
Thank you in advance!!
Solved! Go to Solution.
I have just realized I can do it with CONCATENATE and LEN:
I have just realized I can do it with CONCATENATE and LEN:
User | Count |
---|---|
95 | |
86 | |
78 | |
72 | |
67 |
User | Count |
---|---|
110 | |
104 | |
84 | |
65 | |
63 |