Forum Discussion
MarcusR1
3 years agoHelper II
Using Python Regex to look for values in column
I'm trying to add a column called ofInterest select postcodes that match RG, OX & SA, the column would contain a 1 if the match is found, or 0 if not found. My code is: import pandas as pd impo...
MarcusR1
3 years agoHelper II
Thanks Amit, I have posted it on the Python forum. I think it's still relevant here though, because the Table/Column structure is relevant to PowerBI, and hopefully if I find a solution it will help other PowerBI users.
As an aside, it would be great if PowerBI supported REGEX in DAX or PowerQuery 😉