Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
165 | |
83 | |
68 | |
68 | |
59 |