Forum Discussion
Token Expected error
Hallo Team,
I am trying to add my add custom function to exsting dataset in M query. But I am getting Token in expected error.Any help is greaty appreciated..
------------------
let
#"sco ServiceNow_Outages" = let
Source = Sql.Database("Server", "Database"),
sco_ServiceNow_Outages = Source{[Schema="sco",Item="ServiceNow_Outages"]}[Data],
WHStartD=Number.From(WHStart), // Parameter convert to decimal
WHEndD=Number.From(WHEnd), // Parameter convert to decimal
#"Invoked Custom Function"= Table.AddColumn(sco_ServiceNow_Outages, "Sum of working hours", each fxSOWH(WHStartD, WHEndD, [begin], [end], Holiday))
in
#"Invoked Custom Function"
---------------------------------------
Regards
- Oh, you have 2 let statements but only one in statement
HI Anonymous,
It seems like your query structure formula not completed, you can try to use the following query formula: (power query structure: start with let and end with 'in' and steps)
let #"sco ServiceNow_Outages" = let Source = Sql.Database("Server", "Database"), sco_ServiceNow_Outages = Source{[Schema="sco",Item="ServiceNow_Outages"]}[Data], WHStartD=Number.From(WHStart), // Parameter convert to decimal WHEndD=Number.From(WHEnd), // Parameter convert to decimal #"Invoked Custom Function"= Table.AddColumn(sco_ServiceNow_Outages, "Sum of working hours", each fxSOWH(WHStartD, WHEndD, [begin], [end], Holiday)) in in #"sco ServiceNow_Outages"Regards,
Xiaoxin Sheng
3 Replies
- Oh, you have 2 let statements but only one in statement
- Can you point out where it is giving you that error?
HI Anonymous,
It seems like your query structure formula not completed, you can try to use the following query formula: (power query structure: start with let and end with 'in' and steps)
let #"sco ServiceNow_Outages" = let Source = Sql.Database("Server", "Database"), sco_ServiceNow_Outages = Source{[Schema="sco",Item="ServiceNow_Outages"]}[Data], WHStartD=Number.From(WHStart), // Parameter convert to decimal WHEndD=Number.From(WHEnd), // Parameter convert to decimal #"Invoked Custom Function"= Table.AddColumn(sco_ServiceNow_Outages, "Sum of working hours", each fxSOWH(WHStartD, WHEndD, [begin], [end], Holiday)) in in #"sco ServiceNow_Outages"Regards,
Xiaoxin Sheng