Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
i'm facing an issue and don't know how to resolve it.
i have datas like this :
and i want to transform like this, where the _6 column have only one row
i tried several things (pivot fill up and so on), but without success
any help would be welcome !
Solved! Go to Solution.
let
Origine = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("dY6xDoAgDET/pbMLtKXyLcQBEzed9P9jDwZigstB8njclUKBFgrJY6/3gbsg1GhbCsUpFG5QdE7zoJEz/r/q2WrMQzpNU9cGdFW7ihErTO3UpmrutfozygblwOxHfbAJL00+0BpEa4SbXd1e", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [id = _t, poste = _t, libelle = _t, nombre = _t, taux = _t]),
#"Raggruppate righe" = Table.Group(Origine, {"id"}, {{"all", each Table.First(_)},{"sal", each Record.FromList(List.Skip(_[taux]), List.Skip(_[poste]))}}),
#"Tabella all espansa1" = Table.ExpandRecordColumn(#"Raggruppate righe", "all", {"poste", "libelle", "nombre"}, {"poste", "libelle", "nombre"}),
#"Tabella sal espansa" = Table.ExpandRecordColumn(#"Tabella all espansa1", "sal", {"2391", "2395", "3133", "3137"}, {"2391", "2395", "3133", "3137"})
in
#"Tabella sal espansa"
let
Origine = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("dY6xDoAgDET/pbMLtKXyLcQBEzed9P9jDwZigstB8njclUKBFgrJY6/3gbsg1GhbCsUpFG5QdE7zoJEz/r/q2WrMQzpNU9cGdFW7ihErTO3UpmrutfozygblwOxHfbAJL00+0BpEa4SbXd1e", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [id = _t, poste = _t, libelle = _t, nombre = _t, taux = _t]),
#"Raggruppate righe" = Table.Group(Origine, {"id"}, {{"all", each Table.First(_)},{"sal", each Record.FromList(List.Skip(_[taux]), List.Skip(_[poste]))}}),
#"Tabella all espansa1" = Table.ExpandRecordColumn(#"Raggruppate righe", "all", {"poste", "libelle", "nombre"}, {"poste", "libelle", "nombre"}),
#"Tabella sal espansa" = Table.ExpandRecordColumn(#"Tabella all espansa1", "sal", {"2391", "2395", "3133", "3137"}, {"2391", "2395", "3133", "3137"})
in
#"Tabella sal espansa"
Hello @Anonymous
thank you very much that's exactly what i tried to do.
have a good day
help who can help you: upload a table that can be easily copied!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
21 | |
20 | |
13 | |
13 |