Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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?
Solved! Go to Solution.
Wow...I need coffee. Never crossed my mind. Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |