Forum Discussion

deniztopcu's avatar
deniztopcu
Brass Contributor
Jul 22, 2023
Solved

Pivot table in power query,

hello, there is a help to make the Pivot table in the picture in a power query.   Picture of the table below. It will make the job much easier and simpler in a situation like the first pictur...
excel
power bi
  • SergeiBaklan's avatar
    SergeiBaklan
    Jul 24, 2023

    deniztopcu 

    Afraid not. Power Query works with tables which, returned to the grid, are structured table. Such table has fixed number of columns which are not collapsed/expanded (and partly filtered) as in PivotTable.

     

    You may play with Power Query to return structured table in more suitable way, but in any case that won't be repeating of PivotTable with few fields in Columns.

deniztopcu's avatar
deniztopcu
Brass Contributor
Jul 23, 2023

SergeiBaklan hi,

I want to see this result, which I have obtained with the pivot table, in the power query query.
I know the method you're talking about. Could it be in the power query?

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 24, 2023

deniztopcu 

Afraid not. Power Query works with tables which, returned to the grid, are structured table. Such table has fixed number of columns which are not collapsed/expanded (and partly filtered) as in PivotTable.

 

You may play with Power Query to return structured table in more suitable way, but in any case that won't be repeating of PivotTable with few fields in Columns.

Resources