Hi
i have made below invoke function (name GETSALES) with two parameter
(CODE)=>
(DATE1)=>
let
Source = Folder.Files("G:\SALESDATA\SALES\REVIEW\2018\DSR2018\ActualSales"),
#"Removed Other Columns" = Table.SelectColumns(Source,{"Name", "Folder Path"}),
#"Added Custom" = Table.AddColumn(#"Removed Other Columns", "Custom", each GETDATA([Folder Path]&[Name])),
#"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Name", "Folder Path"}),
#"Expanded Custom" = Table.ExpandTableColumn(#"Removed Columns", "Custom", {"Code", "Date", "Sales2018"}, {"Code", "Date", "Sales2018"}),
#"Filtered Rows" = Table.SelectRows(#"Expanded Custom", each (
i have made below invoke function (name GETSALES) with two parameter
(CODE)=>
(DATE1)=>
let
Source = Folder.Files("G:\SALESDATA\SALES\REVIEW\2018\DSR2018\ActualSales"),
#"Removed Other Columns" = Table.SelectColumns(Source,{"Name", "Folder Path"}),
#"Added Custom" = Table.AddColumn(#"Removed Other Columns", "Custom", each GETDATA([Folder Path]&[Name])),
#"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Name", "Folder Path"}),
#"Expanded Custom" = Table.ExpandTableColumn(#"Removed Columns", "Custom", {"Code", "Date", "Sales2018"}, {"Code", "Date", "Sales2018"}),
#"Filtered Rows" = Table.SelectRows(#"Expanded Custom", each (
Code:
= CODE)),
#"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each [Date] >= DATE1)
in
#"Filtered Rows1"
than i used the invoke function from another table by adding a custom column
=GETSALES([CODE]) but it adding column as Function
how i can create custom column by invoking the function GETSALES