Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
@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 Amit,
Your querys display assending order values but me required only how i am give out format similar type required.
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
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |