i am doing a custom column creation but there is an error message

[Anonymous]

i am trying to a custom column but facing this issue could i get an assist 

@amitchandak 

[v-luwang-msft · Accepted solution]

Hi @Anonymous ,

You enter more "[" then you need.

Number.ToText(Date.Year([[Year_start_date]))&"P"&Number.ToText([[period_number])

Change to :

Number.ToText(Date.Year([Year_start_date]))&"P"&Number.ToText([period_number])

You picture provided:

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[Anonymous]