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 everyone,
I'm currently doing this data transferring for invoice. What I want is for each of the invoice PDF, the row "MÃ ĐIỂM" and "ĐO", would combine together. Anyone have any idea ? Thank you a lot for your support !
how do you want to combine "mã điểm" and "đo" columns. Any other relevant data? Better you update the image you want.
Hi 6677028,
This is the column that I expected it to have. Thank you a lot !
You update the data file, I made for you. Viet Nam
https://drive.google.com/drive/folders/1KAUss0dgP5r3cCDQnXz1SORa008vK9Ef?usp=share_link
Hi 6677028,
Here is my data file, thank you a lot !
You can check. It is correct or not correct
let
Source = Excel.CurrentWorkbook(){[Name="Send_to_community"]}[Content],
#"Filtered Rows" = Table.SelectRows(Source, each ([Column1] = "MÃ ĐIỂM" or [Column1] = "ĐO")),
#"Added Index" = Table.AddIndexColumn(#"Filtered Rows", "Index", 0, 1, Int64.Type),
#"Added Index1" = Table.AddIndexColumn(#"Added Index", "Index.1", 1, 1, Int64.Type),
#"Merged Queries" = Table.NestedJoin(#"Added Index1", {"Index"}, #"Added Index1", {"Index.1"}, "Added Index1", JoinKind.FullOuter),
#"Expanded Added Index1" = Table.ExpandTableColumn(#"Merged Queries", "Added Index1", {"Column1"}, {"Added Index1.Column1"}),
#"Reordered Columns" = Table.ReorderColumns(#"Expanded Added Index1",{"Source.Name", "Column1", "Added Index1.Column1", "Column2", "Column3", "Column4", "Column5", "Column6", "Column7", "Column8", "Index", "Index.1"}),
#"Sorted Rows" = Table.Sort(#"Reordered Columns",{{"Source.Name", Order.Ascending}, {"Column1", Order.Ascending}}),
#"Added Custom" = Table.AddColumn(#"Sorted Rows", "Custom", each if [Added Index1.Column1]= null then [Column1]&" "&"ĐO" else if [Column1]="ĐO" then [Added Index1.Column1]&" "&[Column1] else [Column1]&" "&[Added Index1.Column1]),
#"Filtered Rows1" = Table.SelectRows(#"Added Custom", each ([Source.Name] <> null)),
#"Removed Columns" = Table.RemoveColumns(#"Filtered Rows1",{"Column1", "Added Index1.Column1"}),
#"Reordered Columns1" = Table.ReorderColumns(#"Removed Columns",{"Source.Name", "Custom", "Column2", "Column3", "Column4", "Column5", "Column6", "Column7", "Column8", "Index", "Index.1"})
in
#"Reordered Columns1"
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.