Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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!