I always get a bit concerned when seeing fix ups or bandaids like this placed over raw data that isn’t correct.
Whilst Power BI is really powerful in many ways it’s just can’t fix up data that isn’t correct or captured correctly.
The reality in my view is that placing bandaids and work arounds poor data is a recipe for even further issues down the line.
Fixing the raw data is the most recommended option here. Fixing it at the source is just essential in my view.
Chrs
Sam