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.
Estimados Todos
Necesito tu ayuda.
Tengo dos mesas como abajo. En la tabla 1 tengo los datos y en la tabla 2 el personal actualiza toda la información.
Requisito
Retorno / Resultado
¿Puede sugerir si puedo hacer esto a través de Medir y agregando la Columna?
Gracias
Gaurav
Tabla 1
Código | Categoría | Envío |
Sk | Q | Estándar |
Wf | H | Estándar |
Wf | A | Express |
Wf | U | Express |
Aw | B | Express |
Aw | K | Express |
Aw | B | Express |
Aw | L | Urgente |
Aw | F | Urgente |
Aw | L | Urgente |
F3 | Y | Urgente |
F3 | G | Urgente |
Ah | Y | Estándar |
Ah | Y | Estándar |
Uk | D | Express |
Uk | H | Express |
Gq | W | Urgente |
Gq | O | Urgente |
Gq | D | Estándar |
Tabla 2
Código | Categoría | Identificador |
Sk | Q | QDKRTM |
Wf | H | HNOOWM |
Wf | A | UNOOWM |
Wf | U | UNOOWM |
Aw | B | BRTD |
Aw | K | BRTD |
Aw | B | BRTD |
Aw | L | BRTD |
Aw | F | LRTD |
Aw | L | LRTD |
F3 | Y | Y |
F3 | G | Mrt |
Ah | Y | Y |
Ah | Y | Y |
Uk | D | HL1PYS/YS |
Uk | H | HL1PYS/YS |
Gq | W | DHSMRTOW |
Gq | O | DHSMRTOW |
Gq | D | DHSMRTOW |
Solved! Go to Solution.
nueva columna en la tabla 2o maxx(filter( Table1, Table2[Code] á Table1[Code] && Table1[Category] á left(Table2[Identifier],1)),Table1[Shipping])
nueva columna en la tabla 2o maxx(filter( Table1, Table2[Code] á Table1[Code] && Table1[Category] á left(Table2[Identifier],1)),Table1[Shipping])
Hola @gauravnarchal
eche un vistazo al siguiente código M:
// Table2
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("bdDdCoMgGAbge/E4GGNX0JJyWHNLRUQ6GGSjkwXRye5+39cgZ+7gBd/HH1TnSDH1nmSkeCz+Oc1vGF56/1rGYfQz6TJHJAe7YyhvVbOaKaEzzFUI82M5RO9Mx5Yb6GdMq2gQnki6pk4Ez6+TNZuUJ2h2zVYrSNOq7w4Wze+qxjtRfGV9vFl5sDIwS7jCP8IbUCbhfGGCir9KI+0+", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t, Column3 = _t]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Extracted First Characters" = Table.TransformColumns(#"Promoted Headers", {{"Identifier", each Text.Start(_, 1), type text}})
in
#"Extracted First Characters"
// Table1
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCvZW0lEKBOLgksS8lMSiFKVYnWilcDegiAdWUUcgdq0oKEotLkYIhqIJOoYDBZywCXoTrdIHZG5RempeCULMDYsYmjo3YyA/EouYO5peD6g6FC9iFw0FudoFzZFgQQ80QXdQUIaj2gQW88ci5oJiTywA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Code = _t, Category = _t, Shipping = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Code", type text}, {"Category", type text}, {"Shipping", type text}})
in
#"Changed Type"
// Merge1
let
Source = Table.NestedJoin(Table2, {"Code", "Identifier"}, Table1, {"Code", "Category"}, "Table1", JoinKind.LeftOuter),
#"Expanded Table1" = Table.ExpandTableColumn(Source, "Table1", {"Shipping"}, {"Shipping"})
in
#"Expanded Table1"
Con saludos amables desde la ciudad donde la leyenda del 'Pied Piper de Hamelin' está en casa
FrankAT (Orgulloso de ser un Datanaut)
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 |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
1 |