Forum Discussion
One column values by another column values as single column
HI Power BI export,
my input values is:
| NAME | CATEGORY |
| A | alal |
| A | fes |
| A | fd |
| A | er |
| B | we |
| B | rt |
| C | er |
| C | we |
| C | wr |
| D | t |
Out should be Combine name and Category but Name first values then Catogry values
below is my output
| Name/CATEGORY |
| A |
| alal |
| fes |
| fd |
| er |
| B |
| we |
| rt |
| C |
| er |
| we |
| wr |
| D |
| t |
Thanks
Shanvitha S
Hi, Anonymous
I have a workaroud you can take a try.
Duplcate a new table as "Categeory",create a index column for "Categeory Column"Duplicate a new table as "Name" ,group by "column name" to get the min categeory index.
Subtract 0.1 from the min categeory index value to get the index value of name as below:Then append Table"Name" and Table"Categeory " as a new table:
Sort this table by column index in table visual,the result will show as below:
For more details,please check the attached pbix file.
You can also use dax formula to implement the above steps to create such a table, but it may be more cumbersome.
Best Regards,
Community Support Team _ Eason
3 Replies
Anonymous ,
Create a new table as
new table = Distinct(union(all(Table[Name]), all(Table[category])))
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.Hi, Anonymous
I have a workaroud you can take a try.
Duplcate a new table as "Categeory",create a index column for "Categeory Column"Duplicate a new table as "Name" ,group by "column name" to get the min categeory index.
Subtract 0.1 from the min categeory index value to get the index value of name as below:Then append Table"Name" and Table"Categeory " as a new table:
Sort this table by column index in table visual,the result will show as below:
For more details,please check the attached pbix file.
You can also use dax formula to implement the above steps to create such a table, but it may be more cumbersome.
Best Regards,
Community Support Team _ Eason
