Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I am using direct query to get data from database. Below is requriment
Input Table
Seq_# | Name | Flag |
1 | A | 101 |
1 | B | 102 |
1 | C | 103 |
2 | D | 101 |
2 | E | 102 |
3 | F | 101 |
3 | G | 102 |
3 | H | 103 |
3 | I | 104 |
Output required
Seq_# | Flag_101 | Flag_102 | Flag_103 | Flag_104 |
1 | A | B | C | NULL |
2 | D | E | NULL | NULL |
3 | F | G | H | I |
can any tell me how write dax expressions to give desired output .
Thanks in advance.
Solved! Go to Solution.
Hi @Anonymous ,
Here is my table in Power Query. The only thing I did was to change all columns to text.
Select the flag column. Go to the Transform tab, click on Pivot Column, select Name as the Values Column. Go to the advance options and select don't aggregate. You will see the following.
If this solves your issue, please mark this reply as the solution. Kudos are nice too!
Proud to be a Super User!
table
Drop each column into a matrix as follows:
for this solution.
If
this solves your issue, please
mark it as a solution. Kudos are nice too!
Proud to be a Super User!
i want the data to be transpose in the table level but not in the visualization level .
Hi @Anonymous ,
Here is my table in Power Query. The only thing I did was to change all columns to text.
Select the flag column. Go to the Transform tab, click on Pivot Column, select Name as the Values Column. Go to the advance options and select don't aggregate. You will see the following.
If this solves your issue, please mark this reply as the solution. Kudos are nice too!
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |