I have a workorder table where the location of each WO has an ID. Some years ago, the ID's were updated to a new convention, but the old ones were kept in their original form.
I've set up the slicers to get the information from the location table based on the new convention, but also want them to get the older IDs.
What would be the best approach to this? Convert the older ID's inside WO table to the new convention?