Forum Discussion
Power Query Date
Oi, I want to add a new column to my power query cointaining fixed text + Year + month. I've tried multiple formula's but keep getting errors,.. Example of the text needed "TEST 202208" TE...
Thanks!
Just tried your code and it gives me an error.
"Expression.Error: The name "Year" wasn't recognized. Make sure it's spelled correctly
The easiest was is on Power Query editor ribbon
Add Column -> Column From Examples -> All Columns
and add 2-3 samples, correct text where extra leading zero before month appears
Generated formula will be as Lorenzo suggested, but you don't need to care about syntax and data type.