Forum Discussion

Alex_Serebr's avatar
Alex_Serebr
Frequent Visitor
3 years ago
Solved

Combining filtered column values in Power Query

I am not so familiar with M lang, and am straggling to solve the following problem in Power Query:   I have the table  TABLE1 Date Attribute Value 2023-02-01 AA A1 2023-02-01 AA A2...
Need Help
  • serpiva64's avatar
    serpiva64
    3 years ago

    Hi,

    You have to group by

    then add a custom column

    Table.ToList( Table.RemoveColumns([Count],{"Date", "Attribute"}))

    then extract values

    select your delimiter

    and remove column count

    If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!

     

     

     

     

     

serpiva64's avatar
serpiva64
Solution Sage
3 years ago

Hi,

You have to group by

then add a custom column

Table.ToList( Table.RemoveColumns([Count],{"Date", "Attribute"}))

then extract values

select your delimiter

and remove column count

If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!