Create a subset table from a fact table

[khaledSA]

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 columns in the filtered sub set table. I appreciate your help.

Date	Code	Ind	Val
1/1/2020	A	NM	20
1/6/2020	B	BL	40
1/20/2020	A	NM	60
2/15/2020	A	CX	80
1/5/2020	C	DG	30

 New table:

Date	Code	Ind	Val
1/1/2020	A	NM	20
1/20/2020	A	NM	60
2/15/2020	A	CX	80

[camargos88]

@khaledSA ,

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

[khaledSA]

Hi Recardo,

I have tried that befroe but I get empty columns.

[camargos88 · Accepted solution]

@khaledSA ,

Can you an example of it ?

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

[khaledSA]

Worked after Trim/Clean. Thank you.