Hi All,
My expression checks if column “Angelfish Blanks” contains the value “1”:
SELECT(Student Dinners[Class], CONTAINS([Angelfish Blanks], “1”,),([Class] = [_THISROW].[Class]))
How would I add two further Columns to the CONTAINS part of the expression? I need to add “Dolphin Blanks” and “Pufferfish Blanks” columns.
Thanks, J.
Solved! Go to Solution.
Is this?
SELECT(Student Dinners[Class],
AND(
CONTAINS([Angelfish Blanks], “1”,),
CONTAINS([Dolphin Blanks], “1”,),
CONTAINS([Pufferfish Blanks], “1”,),
[Class] = [_THISROW].[Class]
)
)
Depending on your case and how you want to filter out the row, you change AND expression onto OR,
or you combine AND/OR expression all together.
Is this?
SELECT(Student Dinners[Class],
AND(
CONTAINS([Angelfish Blanks], “1”,),
CONTAINS([Dolphin Blanks], “1”,),
CONTAINS([Pufferfish Blanks], “1”,),
[Class] = [_THISROW].[Class]
)
)
Depending on your case and how you want to filter out the row, you change AND expression onto OR,
or you combine AND/OR expression all together.
Thats great, Thanks!
Your are welcome.
User | Count |
---|---|
41 | |
27 | |
26 | |
20 | |
13 |