Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

SELECTCOLUMNS with Two Filter Arguements?

Hello I have a table similar to this one below advising you of the syntax for each column. Because my data has errors in the Date Column, I have left that column as text and therfore I have no calend...
Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    Anonymous try this:

     

    CSGP Only = 
SELECTCOLUMNS(
    FILTER( 
    'CSLS-PEDU',
    'CSLS-PEDU'[RecordType] IN {"DX"} &&
    NOT 'CSLS=PEDU'[Date]  IN { 20201229, 20201230,20201231 } 
    ),
    "SIN",
    'CSLS-PEDU'[SIN],
    "EffDate",
    'CSLS-PEDU'[EffDate],
    "T4AYear",
    'CSLS-PEDU'[T4AYear],
    "RecordType",
    'CSLS-PEDU'[RecordType],
    "Month",
    'CSLS-PEDU'[Month],
    "Comments",
    'CSLS-PEDU'[Comments],
    "Type",
    'CSLS-PEDU'[Type],
    "Amount",
    'CSLS-PEDU'[Amount]
)

     

    Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

Anonymous try this:

 

CSGP Only = 
SELECTCOLUMNS(
    FILTER( 
    'CSLS-PEDU',
    'CSLS-PEDU'[RecordType] IN {"DX"} &&
    NOT 'CSLS=PEDU'[Date]  IN { 20201229, 20201230,20201231 } 
    ),
    "SIN",
    'CSLS-PEDU'[SIN],
    "EffDate",
    'CSLS-PEDU'[EffDate],
    "T4AYear",
    'CSLS-PEDU'[T4AYear],
    "RecordType",
    'CSLS-PEDU'[RecordType],
    "Month",
    'CSLS-PEDU'[Month],
    "Comments",
    'CSLS-PEDU'[Comments],
    "Type",
    'CSLS-PEDU'[Type],
    "Amount",
    'CSLS-PEDU'[Amount]
)

 

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

Anonymous's avatar
Anonymous
Not applicable
2 years ago

With AND Operator, only 2 parameter filtered. But i passed the problem "&&" operator with no problem. Thanks for your sharing.