Power Query Expert

Job ID: 31343770

Budget: $10 – $30 USD

I need help with passing parameters to SQL query running in Power QUERY. The parameters are coming from a cell in an excel file.

Here goes part of the script
Declare @FromDate Datetime
Set @FromDate ='8/1/21' <------------ Parameters
Declare @ToDate Datetime
Set @FromDate ='8/31/21' <------------ Parameters
Declare @Whse nvarchar(10)
select @FromDate = min(S0.Docdate) from dbo.OINM S0 where S0.Docdate >='[%0]'
select @ToDate = max(S1.Docdate) from dbo.OINM s1 where S1.Docdate <='[%1]'
select @Whse = Max(s2.Warehouse) from dbo.OINM S2 Where S2.Warehouse = '[%2]'
Select @Whse as 'Warehouse', a.Itemcode, max(a.Dscription) as ItemName,
sum(a.OpeningBalance) as OpeningBalance, sum(a.INq) as 'IN', sum(a.OUT) as OUT,
Related categories: SQL Power BI