Forum Discussion
Anonymous
6 years agoNot applicable
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 Service...
- 6 years agoOh, you have 2 let statements but only one in statement
- Anonymous6 years ago
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
Greg_Deckler
6 years agoCommunity Champion
Oh, you have 2 let statements but only one in statement