Forum Discussion
Satish_Kumar
Helper V
9 years agoHow to extract particular column's from a table?
HELP ME OUT....
- 9 years ago
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-msft
Microsoft Employee
9 years ago
You can also use SUMMARIZECOLUMNS Function (DAX) to return one column of a table.
Best Regards,
Herbert