Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |