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.
I have a table like:
person_id | question_code | answer | yes/no |
123 | 1q | yes | yes |
123 | 2q | no | yes |
123 | 3q | no | yes |
123 | 4q | no | yes |
123 | 5q | no | yes |
123 | 6q | no | yes |
So, each person is asked 6 questions, and if at least one answer out of 6 is "yes", then new column (yes/no) should show all "yes" per this person. If all answers are "no", then new column(yes/no) should show all "no" per this person.
How to create this column on dax?
Solved! Go to Solution.
Hi @Gleb
Please use
=
VAR CurrentIDTable =
CALCULATETABLE ( TableName, ALLEXCEPT ( TableName, TableName[person_id] ) )
VAR Answered =
SELECTCOLUMNS ( CurrentIDTable, "@Answered", TableName[Answer] )
RETURN
IF ( "Yes" IN Answered, "Yes", "No" )
Hi @Gleb
Please use
=
VAR CurrentIDTable =
CALCULATETABLE ( TableName, ALLEXCEPT ( TableName, TableName[person_id] ) )
VAR Answered =
SELECTCOLUMNS ( CurrentIDTable, "@Answered", TableName[Answer] )
RETURN
IF ( "Yes" IN Answered, "Yes", "No" )
Yes, right one, thanks a lot!
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 |
---|---|
52 | |
27 | |
24 | |
13 | |
9 |
User | Count |
---|---|
74 | |
58 | |
47 | |
16 | |
12 |