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 | |
36 | |
28 | |
23 | |
16 |