This is what I'm attempting to do. To determine whether a worker has relocated within the last month, I need a query.
The columns I'm using display state as a two-digit code, such as TX. The information about provincial moves is presented as follows in a single column:
I tried dividing the single column by the delimiter, which would result in the creation of an equal number of new columns. then unsuccessfully attempted to insert a custom column that would return (true/false) if there had been any changes.
I'd be looking for a straightforward power query code that, in the example below, will return any and all modifications as true:
It should return "True" if the two-digit state code changed in any way. and "True" only if the two-digit state codes didn't change.