Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
For reference i am only using one column (Cust ID). I feel like this isnt hard but i cant figure out how to get my column data into multiple rows. I have attached an image -- seems pretty straightforward. When i try to pi
Hi,
This M code works
let
Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
Partition = Table.Group(Source, {"Zip"}, {{"Partition", each Table.AddIndexColumn(_, "Index",1,1), type table}}),
#"Expanded Partition" = Table.ExpandTableColumn(Partition, "Partition", {"Cust ID", "Index"}, {"Cust ID", "Index"}),
#"Added Prefix" = Table.TransformColumns(#"Expanded Partition", {{"Index", each "Cust ID" & Text.From(_, "en-IN"), type text}}),
#"Pivoted Column" = Table.Pivot(#"Added Prefix", List.Distinct(#"Added Prefix"[Index]), "Index", "Cust ID")
in
#"Pivoted Column"
Hope this helps.
@Ashish_Mathur That helped me a lot. I was hoping this would help me with two columns instead of one. Any thoughts? I have a 3 rd column CustName which matches w a CustID. Is it possible to end up w columns such as: Zip(unique), CustName1, CustID1, CustName2, CustID2, CustName3, CustID3, etc.
You are welcome. I can get CustName1 ad CustID1 in one cell/column - not in different columns. May be someone else can help.
@themistoklis Thanks for the answer but i was hoping to achieve this table raw In Power Query before loading it to PBI
@Anonymous
Create a new column e.g. Customer No and add the following formula:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |