Token Expected error

[Anonymous]

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

[Greg_Deckler · Accepted solution]

Oh, you have 2 let statements but only one in statement

[v-shex-msft · Accepted solution]

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 · Accepted solution]

Oh, you have 2 let statements but only one in statement

[Greg_Deckler]

Can you point out where it is giving you that error?