Creating Dynamic Columns | Power Query Challenge

===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== CHAPTERS =====
0:00 Intro
0:18 Explaining the Data & the Problem
0:40 Expected Output
1:25 Outro

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

- - - - -
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
Official After The Fall YouTube Channel Below
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)

[NadeemAhmedMd]

You need to first split column using delimiter and unpivot all columns except first. Load as pivot chart and create a measure using concatenatex and keep category as True/false formula and use this measure in values.

Hope this solve.

[kanwalkaur]

I got stuck into the similar problem, after a lot of hassle, I found a lazy trick. For example I had values in a column with the combination of few items say, Mango, Banana, Strawberry, Cheery, Pineapple; firstly I made duplicate columns for each fruit and replaced 1 for Mango and nothing for rest of the values and 0 for null values, likewise I did for each and every fruit, finally find the sum of the values and got the percentage value if desired.

[rubenmunozverdu]

Done! Everything quite easy except the part to dynamically change the type to logical to all columns from the second onwards

[sergioalbar]

where can i find the solved for this case ?

[bakshusyed]

Hai, I am looking for the solution to this below problem, Hope you will help me out
How to create a measure so that I can use a card visual to show number of stores who are selling an average of N Products per month

[christy]

The solution sound nice, but I don't see it can be implemented for data set with a lot of hobbies peer user.... It start to run extremely slow to deploy.... The amount of records is less than 25, 0000 but each can have hobbies of max of 20.

[ProfectusLearning]

I think this is perhaps fairly straight forward: Split the second column by comma and pivot the table with count measure. I had made a video on this a few months back (only the pivoting part)

[MichalTyborski]

Hi,
Sorry for polish words in code, but my excel has only Polish, no English.

let
Źródło = Excel.CurrentWorkbook(){[Name="data"]}[Content],
#"Nagłówki o podwyższonym poziomie" = Table.PromoteHeaders(Źródło, [PromoteAllScalars=true]),
#"Anulowano przestawienie innych kolumn" = o podwyższonym poziomie", {"Name"}, "Atrybut", "Wartość"),
#"Przefiltrowano wiersze" = Table.SelectRows(#"Anulowano przestawienie innych kolumn", each ([Wartość] = true)),
#"Usunięto kolumny" = wiersze", {"Wartość"}),
#"Dodano kolumnę niestandardową" = Table.AddColumn(#"Usunięto kolumny", "Custom", each ", "),
#"Scalono kolumny" = Table.CombineColumns(#"Dodano kolumnę niestandardową", {"Atrybut", "Custom"}, Combiner.CombineTextByDelimiter("", QuoteStyle.None), "Merged"),
#"Pogrupowano wiersze" = Table.Group(#"Scalono kolumny", {"Name"}, {{"Combination", each Text.Combine([Merged]), type text}}),
#"Dodano kolumnę niestandardową1" = Table.AddColumn(#"Pogrupowano wiersze", "Final", each Text.Reverse(Text.Middle(Text.Reverse([Combination]), 2)), type text),
#"Usunięto inne kolumny" = Table.SelectColumns(#"Dodano kolumnę niestandardową1", {"Name", "Final"})
in
#"Usunięto inne kolumny"

My final table has 2 columns, the same as yours target.