Forum Discussion
Helper VHow to extract particular column's from a table?
HELP ME OUT....
There are two ways of doing this into powerbi.
1. In the Query Editor, Select particular column, Right Click and Remove other columns.
2. Connect your model to DAX Studio and Write the below syntax.
EVALUATE
TABLE[COLUMN NAME]
Run this Query againest your model and you can extract the results into .TXT file.
3. In the Query editor, You can select the particular column in your table and convert it to the list.
2 Replies
- BhaveshPatel
Super User
There are two ways of doing this into powerbi.
1. In the Query Editor, Select particular column, Right Click and Remove other columns.
2. Connect your model to DAX Studio and Write the below syntax.
EVALUATE
TABLE[COLUMN NAME]
Run this Query againest your model and you can extract the results into .TXT file.
3. In the Query editor, You can select the particular column in your table and convert it to the list.
v-haibl-msftMicrosoft Employee
You can also use SUMMARIZECOLUMNS Function (DAX) to return one column of a table.
Best Regards,
Herbert