Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a table called Feedback with the many columns, however, I want to extract only a few columns into a new table
Following are the columns that need to be put in a new table
Question Text
Response Text
Date
Please tell me how this can be achieved? I tried using SELECTCOLUMNS but got an error saying that "got multiple values and expected single values"
Solved! Go to Solution.
Add a calulcated colum defined as RELATED(whatever the field is named in the related table)
@b_minesh , refer this video how to copy value from one tbale to another
Hi @b_minesh ,
Please let us know if the replies above are helpful.
If they are, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If not, please give us more details.
Best Regards,
Icey
Try the LOOKUPVALUE function
@b_minesh , refer this video how to copy value from one tbale to another
Add a calulcated colum defined as RELATED(whatever the field is named in the related table)
When I use the RELATED function, the table that I want the column from does not show up.
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |