Forum Discussion
Chitemerere
6 years agoResponsive Resident
Extract values from string using DAX
I have the following live Dataset (column "Response") being generated from Microsoft Flow and written to Power BI dataset: Response Value Not available 0 1500 1500 200...
Greg_Deckler
6 years agoCommunity Champion
Chitemerere - Well, one way would be to use DAX to turn your strings into table variables. Then have a table that lists every possible charater you want to remove and remove any rows in that table then translate it back to a string. Although the years are going to pose problems. You can see some of the basic techniques here:
https://community.powerbi.com/t5/Quick-Measures-Gallery/ARABIC/m-p/1083214#M519
Chitemerere
6 years agoResponsive Resident
Thanks Greg for your input, most appreciated.
Regards,
Chris