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.
Hello,
The Task is to append 3 queries, filter [Area Responsable]= "Tintoreria" and [Disposición] <> "Aprobado", after this if duplicate "Lote" leave earliest result ( no duplicates)
I have been able to append the queries:
let Source = Table.Combine({PNC_TELA, PNC_PARTES_CORTADAS, TONO_MALO}), #"Removed Other Columns" = Table.SelectColumns(Source,{"Fecha de Ingreso", "Lote", "Defecto 1", "Disposición", "Proceso Responsable"}), #"Changed Type" = Table.TransformColumnTypes(#"Removed Other Columns",{{"Fecha de Ingreso", type date}}) in #"Changed Type"
One more question, Can I add a column to wach row telling me from which Database that line is from?
Thank you
Solved! Go to Solution.
You can sort on date and than remove duplicates as illustrated in this short video.
@ratercero wrote:
Hello,
The Task is to append 3 queries, filter [Area Responsable]= "Tintoreria" and [Disposición] <> "Aprobado", after this if duplicate "Lote" leave earliest result ( no duplicates)
I have been able to append the queries:
let Source = Table.Combine({PNC_TELA, PNC_PARTES_CORTADAS, TONO_MALO}), #"Removed Other Columns" = Table.SelectColumns(Source,{"Fecha de Ingreso", "Lote", "Defecto 1", "Disposición", "Proceso Responsable"}), #"Changed Type" = Table.TransformColumnTypes(#"Removed Other Columns",{{"Fecha de Ingreso", type date}}) in #"Changed Type"
One more question, Can I add a column to wach row telling me from which Database that line is from?
Thank you
For the last question, you can add a column valuing the database name in each table before combining them.
For the first question, could you please post some sample data for the 3 tables and expected output?
Any ideas anyone else?
@ratercero: the question was already answered by @Eric_Zhang:
"For the last question, you can add a column valuing the database name in each table before combining them."
Translated into code, e.g.:
let Source1 = Table.AddColumn(PNC_TELA, "Source", each "PNC_TELA"), Source2 = Table.AddColumn(PNC_PARTES_CORTADAS, "Source", each "PNC_PARTES_CORTADAS"), Source3 = Table.AddColumn(TONO_MALO, "Source", each "TONO_MALO"), Source = Table.Combine({Source1, Source2, Source3}), #"Removed Other Columns" = Table.SelectColumns(Source,{"Fecha de Ingreso", "Lote", "Defecto 1", "Disposición", "Proceso Responsable", "Source"}), #"Changed Type" = Table.TransformColumnTypes(#"Removed Other Columns",{{"Fecha de Ingreso", type date}}) in #"Changed Type"
Hello @MarcelBeug,
I used @Eric_Zhang recomendation and this is my code:
let Source1 = Table.AddColumn(PNC_TELA, "Source", each "PNC_TELA"), Source2 = Table.AddColumn(PNC_PARTES_CORTADAS, "Source", each "PNC_PARTES_CORTADAS"), Source3 = Table.AddColumn(TONO_MALO, "Source", each "TONO_MALO"), Source = Table.Combine({Source1, Source2, Source3}), #"Removed Other Columns" = Table.SelectColumns(Source,{"Fecha de Ingreso", "Lote", "Defecto 1", "Disposición", "Proceso Responsable", "Source"}), #"ChangedType" = Table.TransformColumnTypes(#"Removed Other Columns",{{"Fecha de Ingreso", type date}}), #"Filtered Table" =Table.SelectRows(ChangedType, each [Proceso Responsable] = "Tintoreria" and [Disposición]<>"Aprobado" ) in #"Filtered Table"
It partially works for my final objective since I need to only the first time a batch # shows and
[Proceso Responsable] = "Tintoreria" and [Disposición]<>"Aprobado"
, if it repeats with another defects the current code is leaving that entry too.
You can sort on date and than remove duplicates as illustrated in this short video.
No: just add these steps to your query, so it will be part of the refresh.
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |