Please review the media film on the presentation file.
Posts by Q2Be
-
-
Hello,
Sorry for delay, please note that these 2 codes are not working as per earlier post.
thanks and regards,
let
Source = Excel.Workbook(File.Contents("C:\Users\XYZ\Downloads\Book1.xlsx"), null, true),
#"Grouped Rows" = Table.Group(Source, {"discount %"}, {{"Data", each _, type table [product name=number, #"discount %"=number, attracting level=text]}}),
#"Expanded Data" = Table.ExpandTableColumn(#"Grouped Rows", "Data", {"product name", "attracting level"}, {"product name", "attracting level"}),
#"Sorted Rows" = Table.Sort(#"Expanded Data",{{"discount %", Order.Ascending}})
in
#"Sorted Rows"
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Grouped Rows" = Table.Group(Source, {"discount %"}, {{"Data", each _, type table [product name=number, #"discount %"=number, attracting level=text]}}),
#"Expanded Data" = Table.ExpandTableColumn(#"Grouped Rows", "Data", {"product name", "attracting level"}, {"product name", "attracting level"}),
#"Sorted Rows" = Table.Sort(#"Expanded Data",{{"discount %", Order.Ascending}})
in
-
-
Tried use the earlier code, unfortunately I got an error as per the attached 1st snapshot; so I did replaced "Second Line" to be: Source = Excel.Workbook(File.Contents("C:\Users\xyz\Downloads\Book1.xlsx"), null, true), afterward the code remains cant run correctly there's a new error message according to 2nd snapshot.
Thanks and regards,
-
-
Hello,
I am preparing personal excel sheet, and need to has a feature of showing all products which were inputted, which were got same discount % by visiting retail shop websites for easy reference and make it more convince outputs data to me.Thanks and regards,