Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I have a table with many many columns (the name of the colums are a,b,c, ... z.
Now I would like to generate a new table, which includes only a subset of the old table, let's say coulms a,k,r.
May I ask you to help out.
Thx
Szymon
Solved! Go to Solution.
have you tried this function?
if this is not what you want, could you pls provide some sample data and expected output?
Proud to be a Super User!
do you mean DAX? pls see the function below
https://docs.microsoft.com/en-us/dax/selectcolumns-function-dax
Proud to be a Super User!
Yes, I mean DAX.
But, what I understand, the SELECTCOLUMNS gives a scalar value and not the single columns.
have you tried this function?
if this is not what you want, could you pls provide some sample data and expected output?
Proud to be a Super User!
you can try reference a new table, then choose columns
Proud to be a Super User!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |