Forum Discussion

khaledSA's avatar
khaledSA
Frequent Visitor
6 years ago
Solved

Create a subset table from a fact table

I need to creat a sub set table with all the columns in the main table but filtered with value "A" in the Code column. I need all related rows in the coulmns to be able to add additional calculated c...
  • camargos88's avatar
    camargos88
    6 years ago

    khaledSA ,

     

    Can you an example of it ?

    Maybe your column needs to be cleaned. Have you tried TRIM/CLEAN it on Query Editor ?

camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

khaledSA ,

 

TABLE = FILTER(TABLE, TABLE[CODE] = "A")

 

khaledSA's avatar
khaledSA
Frequent Visitor
6 years ago

Hi Recardo,

I have tried that befroe but I get empty columns.

  • camargos88's avatar
    camargos88
    Icon for Community Champion rankCommunity Champion
    6 years ago

    khaledSA ,

     

    Can you an example of it ?

    Maybe your column needs to be cleaned. Have you tried TRIM/CLEAN it on Query Editor ?

    • khaledSA's avatar
      khaledSA
      Frequent Visitor
      6 years ago

      Worked after Trim/Clean. Thank you.