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.
¡Hola!
Estoy luchando para crear la columna [Min Projected EOH Date] a continuación como una columna personalizada en M en la misma tabla sin cambiar el resto de la tabla.
Tbl EOH real | Proyectado EOH Tbl | Fecha | Min Projected EOH Date |
tbl_ActualEOH | Null | 3/30/2020 | 4/27/2020 |
tbl_ActualEOH | Null | 3/30/2020 | 4/27/2020 |
tbl_ActualEOH | Null | 3/30/2020 | 4/27/2020 |
tbl_ActualEOH | Null | 4/6/2020 | 4/27/2020 |
tbl_ActualEOH | Null | 4/6/2020 | 4/27/2020 |
tbl_ActualEOH | Null | 4/6/2020 | 4/27/2020 |
tbl_ActualEOH | Null | 4/6/2020 | 4/27/2020 |
tbl_ActualEOH | Null | 4/13/2020 | 4/27/2020 |
tbl_ActualEOH | Null | 4/13/2020 | 4/27/2020 |
tbl_ActualEOH | Null | 4/13/2020 | 4/27/2020 |
tbl_ActualEOH | Null | 4/13/2020 | 4/27/2020 |
tbl_ActualEOH | Null | 4/20/2020 | 4/27/2020 |
tbl_ActualEOH | Null | 4/20/2020 | 4/27/2020 |
tbl_ActualEOH | Null | 4/20/2020 | 4/27/2020 |
tbl_ActualEOH | Null | 4/20/2020 | 4/27/2020 |
tbl_ActualEOH | Null | 4/27/2020 | 4/27/2020 |
tbl_ActualEOH | Null | 4/27/2020 | 4/27/2020 |
tbl_ActualEOH | Null | 4/27/2020 | 4/27/2020 |
tbl_ActualEOH | Null | 4/27/2020 | 4/27/2020 |
Null | tbl_ProjectEOH | 4/27/2020 | 4/27/2020 |
Null | tbl_ProjectEOH | 4/27/2020 | 4/27/2020 |
Null | tbl_ProjectEOH | 4/27/2020 | 4/27/2020 |
Null | tbl_ProjectEOH | 4/27/2020 | 4/27/2020 |
Null | tbl_ProjectEOH | 5/4/2020 | 4/27/2020 |
tbl_ActualEOH | Null | 5/4/2020 | 4/27/2020 |
tbl_ActualEOH | Null | 5/4/2020 | 4/27/2020 |
Null | tbl_ProjectEOH | 5/4/2020 | 4/27/2020 |
tbl_ActualEOH | Null | 5/4/2020 | 4/27/2020 |
Null | tbl_ProjectEOH | 5/4/2020 | 4/27/2020 |
Null | tbl_ProjectEOH | 5/4/2020 | 4/27/2020 |
Null | tbl_ProjectEOH | 5/4/2020 | 4/27/2020 |
Null | tbl_ProjectEOH | 5/4/2020 | 4/27/2020 |
Null | tbl_ProjectEOH | 5/4/2020 | 4/27/2020 |
Null | tbl_ProjectEOH | 5/4/2020 | 4/27/2020 |
tbl_ActualEOH | Null | 5/4/2020 | 4/27/2020 |
Null | tbl_ProjectEOH | 5/11/2020 | 4/27/2020 |
Null | tbl_ProjectEOH | 5/11/2020 | 4/27/2020 |
Null | tbl_ProjectEOH | 5/11/2020 | 4/27/2020 |
Null | tbl_ProjectEOH | 5/11/2020 | 4/27/2020 |
Null | tbl_ProjectEOH | 5/11/2020 | 4/27/2020 |
Null | tbl_ProjectEOH | 5/11/2020 | 4/27/2020 |
Null | tbl_ProjectEOH | 5/11/2020 | 4/27/2020 |
Null | tbl_ProjectEOH | 5/11/2020 | 4/27/2020 |
Null | tbl_ProjectEOH | 5/11/2020 | 4/27/2020 |
He intentado utilizar List.Min sin embargo devuelve "no se puede convertir el tipo de fecha a tipo de lista"
¡Gracias!
Entonces, ¿eses a la fecha mínima en la que "Projected EOH Tbl" no es nulo entonces?
Pude hacer esto:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WKknKiXdMLilNzHH191DSUcorzckBUsb6xgb6RgZGBkC2ib6ROYQdqzOAGkz0zYa4ekPjoa/BiNRIG4wazIeMBqgCkL6Aovys1OQSiMbhosNU34SkkKKaepo7iGQLRqQG6oWqoeGojkGvIxYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Actual EOH Tbl" = _t, #"Projected EOH Tbl" = _t, Date = _t, #"Min Projected EOH Date" = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Actual EOH Tbl", type text}, {"Projected EOH Tbl", type text}, {"Date", type date}, {"Min Projected EOH Date", type date}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Min Projected EOH Date", "Desired Min Projected EOH Date"}}),
#"Added Custom" = Table.AddColumn(#"Renamed Columns", "Min Projected EOH Date", each Table.Min(Table.SelectRows(#"Renamed Columns",each ([Projected EOH Tbl] = "tbl_ProjectEOH")), { "Date" })),
#"Expanded Min Projected EOH Date" = Table.ExpandRecordColumn(#"Added Custom", "Min Projected EOH Date", {"Date"}, {"Min Projected EOH Date.Date"})
in
#"Expanded Min Projected EOH Date"
¡Muchas gracias! ¡Pude usar tu código para que funcione en mi consulta!
#"Added Custom1" = Table.AddColumn(#"Changed Type", "Min Projected EOH Date", each Table.Min(Table.SelectRows(#"Changed Type",each ([Projected EOH Tbl] = "tbl_ProjectEOH")), { "Date" })),
#"Expanded Min Projected EOH Date" = Table.ExpandRecordColumn(#"Added Custom1", "Min Projected EOH Date", {"Date"}, {"Min Projected EOH Date.Date"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Expanded Min Projected EOH Date",{{"Min Projected EOH Date.Date", type date}}),
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 |