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.
Hi all,
Does any one know how to shaping the values of Tecn. of one column for a new colum whit all the Tecnologies fot that SITE
The new colum is Tecnologies, does any one know hot to get it?
SITE | Tecn. | Tecnologies |
SITE_A | 2G | 2G_3G_4G |
SITE_A | 3G | 2G_3G_4G |
SITE_A | 4G | 2G_3G_4G |
SITE_B | 3G | 3G |
SITE_C | 2G | 2G_3G |
SITE_C | 3G | 2G_3G |
SITE_D | 2G | 2G_3G_4G_5G |
SITE_D | 3G | 2G_3G_4G_5G |
SITE_D | 4G | 2G_3G_4G_5G |
SITE_D | 5G | 2G_3G_4G_5G |
Solved! Go to Solution.
HI @wolfy_,
IF you mean to concatenate the 'Tecn' field values based on site group, I'd like to suggest you add a calculated column with concatenatex function.
Tecnologies =
CONCATENATEX ( FILTER ( Table, [SITE] = EARLIER ( Table[SITE] ) ), [Tecn.], "_" )
Regards,
Xiaoxin Sheng
Hi,
This M code works
let
Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
#"Grouped Rows" = Table.Group(Source, {"SITE"}, {{"All Technologies", each Text.Combine([#"Tecn."]
,","), type text}, {"All", each _, type table [SITE=text, #"Tecn."=text]}}),
#"Expanded All" = Table.ExpandTableColumn(#"Grouped Rows", "All", {"Tecn."}, {"Tecn."}),
#"Reordered Columns" = Table.ReorderColumns(#"Expanded All",{"SITE", "Tecn.", "All Technologies"})
in
#"Reordered Columns"
Hope this helps.
HI @wolfy_,
IF you mean to concatenate the 'Tecn' field values based on site group, I'd like to suggest you add a calculated column with concatenatex function.
Tecnologies =
CONCATENATEX ( FILTER ( Table, [SITE] = EARLIER ( Table[SITE] ) ), [Tecn.], "_" )
Regards,
Xiaoxin Sheng
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 |
---|---|
109 | |
100 | |
85 | |
77 | |
65 |
User | Count |
---|---|
120 | |
111 | |
95 | |
83 | |
75 |