The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
248 | |
124 | |
111 | |
78 | |
78 |