Table from input variable

sadath

Board Regular
Joined
Oct 10, 2004
Messages
245
Hi

I am trying to create a table from date input variable

PeriodFrom variable

let
Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"DateFr", type date}}),
AddCri01 = Record.Field(#"Changed Type"{0},"DateFr")
in
AddCri01


PeriodTo variable

let
Source = Excel.CurrentWorkbook(){[Name="Table4"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"DateTo", type date}}),
AddCri02 = Record.Field(#"Changed Type"{0},"DateTo")
in
AddCri02


but when i put the above two variable in the below code its not workind

let
AddCri01 = PeiodFrom
AddCri02 = PeiodTo
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}, {"Sales", Int64.Type}, {"GC", Int64.Type}}),
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each [Date] >= PeiodFrom and [Date] <= PeiodTo)
in
#"Filtered Rows"
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Watch MrExcel Video

Forum statistics

Threads
1,109,020
Messages
5,526,293
Members
409,694
Latest member
bastos21

This Week's Hot Topics

Top