Forum Discussion
Pivot in direct Query
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.
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!
4 Replies
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!
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!