Creating DATEID column in Power Query causes Stack Overflow

0
votes

Error Message

Expression.Error: Evaluation resulted in a stack overflow and cannot continue.

I'm trying to add a custom column so I have a DATEID in my Date table it causes a stack overflow. Thought this would be the forum for this error. The date table contains dates from 1980 to 2038.

Formulae for new column in DATE TABLE:

Table.AddColumn(Time, "DateKey", 
    each 
      Number.ToText(Date.Year([Date])) &
      Text.PadStart(Number.ToText(Date.Month([Date])),2,"0") &
      Text.PadStart(Number.ToText(Date.Day([Date])),2,"0"
    )
  )
1
powerbipowerquerym

1 Answers

0
votes

I'm not sure why it's throwing an error but you may have better luck with a cleaner definition using the function Date.ToText.

Date.ToText([Date], "yyyyMMdd")