Forum Discussion

ARob198's avatar
ARob198
Icon for Helper IV rankHelper IV
6 years ago
Solved

Create a new calculated table by filtering an existing table and selecting only specific columns

Hello,   I am trying to create a new table based on an existing table.  I would like to filter the existing table and also select only specific columns from the old table and put them into my new t...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    ARob198 try this

     

    SELECTCOLUMNS(
FILTER('FundCustValAll',
'FundCustValAll'[NAME DETAIL]IN 
{ 
"C1_F1_INTERNAL", 
"C1_F2_INTERNAL",
"C1_F3_INTERNAL",
"C2_F1_INTERNAL",
"C2_F2_INTERNAL",
 "C2_F3_INTERNAL",
"C3_F1_INTERNAL",
"C3_F2_INTERNAL",
"C3_F3_INTERNAL"
}
),
"NAME DETAIL", [NAME DETAIL], 
"Date", [DATE], 
"Ownership %", [Ownership %], 
"Fund", [FUND]
)

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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
    6 years ago

    ARob198 ctrl+ enter and here are the shortcuts

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡

ARob198's avatar
ARob198
Icon for Helper IV rankHelper IV
6 years ago

Thank you.  I will try it.  How do you add the new rows to your code (to make it easier to read)?  When I type the Enter button, it just submits the code.  : )

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

ARob198 ctrl+ enter and here are the shortcuts

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡