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.
i have the same source of Data and the same code under (advanced editoris window') that i just copied from the first project into the second but an applied steps called "colonne de table developpée" equivalent of developped colomns in english give a different result and it affects the rest of the steps
Solved! Go to Solution.
Try posting the M code from the advanced editor. Determining issues in a picture is difficult if not impossible.
Try posting the M code from the advanced editor. Determining issues in a picture is difficult if not impossible.
let
Source = Folder.Files("C:\Users\MBOUGA4F\Desktop\ENDESA\ANNEXES\ALOCAT_Histo\012019\ALOCATJ"),
#"Split Column by Delimiter" = Table.SplitColumn(Source, "Name", Splitter.SplitTextByDelimiter("_", QuoteStyle.Csv), {"Name.1", "Name.2", "Name.3", "Name.4", "Name.5", "Name.6", "Name.7"}),
#"Changed Type with Locale" = Table.TransformColumnTypes(#"Split Column by Delimiter", {{"Name.2", type date}}, "fr-FR"),
#"Removed Other Columns" = Table.SelectColumns(#"Changed Type with Locale",{"Content", "Name.2", "Name.3"}),
#"Fichiers masqués filtrés1" = Table.SelectRows(#"Removed Other Columns", each [Attributes]?[Hidden]? <> true),
#"Appeler une fonction personnalisée1" = Table.AddColumn(#"Fichiers masqués filtrés1", "Transformer le fichier", each #"Transformer le fichier"([Content])),
#"Autres colonnes supprimées1" = Table.SelectColumns(#"Appeler une fonction personnalisée1", {"Transformer le fichier","Name.3"}),
#"Colonne de tables développée1" = Table.ExpandTableColumn(#"Autres colonnes supprimées1", "Transformer le fichier", Table.ColumnNames(#"Transformer le fichier"(#"Exemple de fichier"))),
#"Type modifié" = Table.TransformColumnTypes(#"Colonne de tables développée1",{{"Day", type date}, {"ListOfPointAllocations", type any}, {"ListOfOtherAllocations", type any}}),
#"Expanded ListOfPointAllocations" = Table.ExpandTableColumn(#"Type modifié", "ListOfPointAllocations", {"PointAllocation"}, {"PointAllocation"}),
#"Expanded PointAllocation" = Table.ExpandTableColumn(#"Expanded ListOfPointAllocations", "PointAllocation", {"ListOfDeliveryPoints"}, {"ListOfDeliveryPoints"}),
#"Expanded ListOfDeliveryPoints" = Table.ExpandTableColumn(#"Expanded PointAllocation", "ListOfDeliveryPoints", {"DeliveryPoint"}, {"DeliveryPoint"}),
#"Expanded DeliveryPoint" = Table.ExpandTableColumn(#"Expanded ListOfDeliveryPoints", "DeliveryPoint", {"Point", "Quantity", "Quantityp", "Quantitynp"}, {"Point", "Quantity", "Quantityp", "Quantitynp"}),
#"Filtered Rows" = Table.SelectRows(#"Expanded DeliveryPoint", each ([Point] <> null)),
#"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"ListOfOtherAllocations"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Removed Columns",{{"Quantity", type number}, {"Quantityp", type number}, {"Quantitynp", type number}}),
#"Personnalisée ajoutée" = Table.AddColumn(#"Changed Type1", "Personnalisé", each Date.Month([Day])),
#"Colonnes renommées" = Table.RenameColumns(#"Personnalisée ajoutée",{{"Personnalisé", "Month"}}),
#"Personnalisée ajoutée1" = Table.AddColumn(#"Colonnes renommées", "Year", each Date.Year([Day])),
#"Filtered Rows2" = Table.SelectRows(#"Personnalisée ajoutée1", each true),
#"Filtered Rows1" = Table.SelectRows(#"Filtered Rows2", each true),
#"Grouped Rows" = Table.Group(#"Filtered Rows1", {"Point", "Month", "Year", "Name.3"}, {{"Qty", each List.Sum([Quantity]), type number}, {"QtyP", each List.Sum([Quantityp]), type number}, {"QtyNP", each List.Sum([Quantitynp]), type number}}),
#"Colonnes renommées1" = Table.RenameColumns(#"Grouped Rows",{{"Name.3", "TypeConso"}})
in
#"Colonnes renommées1"
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.