Forum Discussion
Helper IRemove Characters from String which are present elsewhere in the string
Hi Donerandparmo1,
I would suggest instead of using text. remove, you should extract the date from the column by using
Date.FromText(
Text.Select([Start Date], {"0".."9","-","/"})
) otherwise null🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
Super UserHi Donerandparmo1,
I would suggest instead of using text. remove, you should extract the date from the column by using
Date.FromText(
Text.Select([Start Date], {"0".."9","-","/"})
) otherwise null
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
Helper IGreat idea, mate!