Combining two fields inside a dimension

[Anonymous]

Dear PowerBI community,

I am trying to combine the "Outlets - Others" and "Outlets - Singpost" fields inside the dimension "SalesCodeName". I am thinking of renaming the fields of "Outlets - Others" to "Outlets - Singpost" so that these two fields' dataset could be combined together.

I tried to research but to no avail. Could anyone please advise me? Thank you!

[Anonymous · Accepted solution]

@Anonymous - Go like this-

Filter "Outlets - Others" on the column SalesCodeName.

Now go replace values and replace "Outlets - Others" to "Outlets - Singpost".

That would work.

[Icey · Accepted solution]

Hi @Anonymous ,

Just like what @Anonymous mentioned, go to Power Query Editor and replace value "Outlets - Others" with "Outlets - Singpost".

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

@Anonymous - Go like this-

Filter "Outlets - Others" on the column SalesCodeName.

Now go replace values and replace "Outlets - Others" to "Outlets - Singpost".

That would work.