Forum Discussion
Data Modeling for a concatenated column
I am working on a project in power bi when I making the data modeling, one of the columns has multiple values about country code, I want to separate them and then transform them into a dimension tabl...
NaveenGandhi
Memorable Member
Memorable MemberHello Mays-Alreem
If you want the dimension table(Unique COD Country Sliicer) to just filter the data in a table visual, I have a workaround. But there isn't a way to normalize this further and create many-1 relationship, since 1 ID has multiple CODCountry.
Share a sample data if you want solution just for filtering.
Let me know if this helps!
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!