Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |