Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to Solution.
Can you an example of it ?
Maybe your column needs to be cleaned. Have you tried TRIM/CLEAN it on Query Editor ?
TABLE = FILTER(TABLE, TABLE[CODE] = "A")
Hi Recardo,
I have tried that befroe but I get empty columns.
Can you an example of it ?
Maybe your column needs to be cleaned. Have you tried TRIM/CLEAN it on Query Editor ?
Worked after Trim/Clean. Thank you.
User | Count |
---|---|
53 | |
22 | |
18 | |
18 | |
13 |
User | Count |
---|---|
89 | |
87 | |
50 | |
34 | |
22 |