One column values by another column values as single column

[Anonymous]

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

[amitchandak]

@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.

[Anonymous]

Hi Amit,

Your querys display assending order values but me required only how i am give out format similar type required.

Thanks

Shanvitha S

[v-easonf-msft · Accepted solution]

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