When I’m in Power BI and Edit data source, I want to add a column referencing another and stripping only a piece of that column, in this case I have a field 2016-01 where I want to strip out the 01 as a Month Column. I add the Column and get to the formula screen. A right formula doesn’t work, so I click learn more, which launches me to here
https://support.office.com/en-us/article/Learn-about-Power-Query-formulas-6bc50988-022b-4799-a709-f8...
I then find the link to a reference of formulas, awesome!
https://msdn.microsoft.com/library/Mt253322?ui=en-US&rs=en-US&ad=US
But then I try a few (text.to, text.remove), and they don’t work, e.g. =text.remove([Cost_Plan_Year_Month],1,5), it indicates no syntax errors.
It errors out with this:
Expression Error: The name 'text.remove' wasn't recognized. Make sure it's spelled correctly
Is there a reference for formulas that will work with Power BI in the Get Data > Edit portion of the tool?
More specifically, what formula can I use to strip out the last two characters of this field?
