Forum Discussion

Tober1996's avatar
Tober1996
Helper I
6 years ago
Solved

Table filtering while import

Hello experts, I would like to import a table whose first column contains an order number, but for which there are several rows, since there are different processes for each order. now i don't want t...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi Tober1996 ,

     

    Please try grouping like this:

    Add a step in the advanced editor after expanding the table:

    Table.SelectRows(#"Expanded expand",each([Max]=[expand.flow_id]))

    Sample .pbix

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Tober1996's avatar
    Tober1996
    6 years ago

    Hi together, thank you very much! The advanced grouping ist the solution, but it is not needed to write the extra code to see the other columns. You only have to press the button with the two arrows in the headline of the new column. than all existings columns expand and are shown again. ðŸ˜„ 

V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago

Hi Tober1996 ,

 

Please try grouping like this:

Add a step in the advanced editor after expanding the table:

Table.SelectRows(#"Expanded expand",each([Max]=[expand.flow_id]))

Sample .pbix

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Tober1996's avatar
Tober1996
Helper I
6 years ago

Hi together, thank you very much! The advanced grouping ist the solution, but it is not needed to write the extra code to see the other columns. You only have to press the button with the two arrows in the headline of the new column. than all existings columns expand and are shown again. ðŸ˜„