How to enable left join with mysql group concat csv merged instances of right side column values

0 votes

Any insights on how to address the power bi power query?

Nov 12, 2020 in Power BI by Roshni
• 10,480 points
94 views

1 answer to this question.

0 votes

You can look for this:

 

let
    Source = Table.NestedJoin(#"mysqldb support_request", {"id"}, #"mysqldb support_request_tag"[[#"support_request_id"], [#"tag_name"]], {"support_request_id"}, "tag_name_csv", JoinKind.LeftOuter),
    #"Transformed tags" = Table.TransformColumns(Source, {{"tag_name_csv", each Text.Combine(_[#"tag_name"], ", "), type text}})
in
    #"Transformed tags"
answered Nov 12, 2020 by Gitika
• 65,950 points

Related Questions In Power BI

0 votes
0 answers

How to count of category values in a column?

How to count of category values in ...READ MORE

Oct 30, 2019 in Power BI by ch
• 3,450 points
263 views
0 votes
1 answer

Calculated column with the sum of values from many columns in a row

Hi, You can create a new column by ...READ MORE

answered Mar 14, 2019 in Power BI by Cherukuri
• 33,010 points
441 views
0 votes
1 answer

How to show sub total to sub groups along with individual values?

Hi Lassya, Follow the below steps: 1. Right click ...READ MORE

answered May 21, 2019 in Power BI by anonymous
• 33,010 points
112 views
0 votes
0 answers

How to create a custom column for comparing between of 2 numbers?

Hi How do I create a custom ...READ MORE

Jun 28, 2019 in Power BI by Phalguni
• 1,020 points
163 views
+1 vote
1 answer

display the count of rows matching some criteria

Do you want to show a table ...READ MORE

answered Aug 5, 2019 in Power BI by anonymous
• 33,010 points
279 views
0 votes
3 answers

How to add an extra column to the existing table in power bi query editor?

Click on edit queries after loading source ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,480 points
27,738 views
0 votes
1 answer

How to demote Headers in Power BI query editor?

Hi, There are the steps which you can ...READ MORE

answered Feb 3, 2020 in Power BI by Jitesh
9,993 views
0 votes
0 answers

How to Split Columns in Power BI?

Can anyone demonstrate how to split columns ...READ MORE

Feb 4, 2020 in Power BI by Roshni
• 10,480 points
174 views
+3 votes
3 answers

How to replace null values with custom values in Power BI(power query editor)?

Hi Nithin, To fill or replace the null or ...READ MORE

answered Mar 8, 2019 in Power BI by Cherukuri
• 33,010 points
70,121 views
0 votes
1 answer

How to Toggle Between Two Option and Make it Interact with the rest of the Visualizations in a Report?

Toggling is an action that is achieved ...READ MORE

answered Oct 20, 2020 in Power BI by anonymous
• 65,950 points
110 views