Forum Discussion

Justas4478's avatar
Justas4478
Post Prodigy
1 year ago
Solved

Customer group split based on stores

Hi, I have customer group that holds stores for UK & NI in the same group. I want to split it in to two groups Stores NI and whats left Stores UK. The problem is NI stores get added and removed eve...
Need Help
  • Justas4478's avatar
    Justas4478
    1 year ago

    SamWiseOwl I think I manage to find solution in M code:
    Table.ReplaceValue(#"Renamed Columns1",each [Customer Group Description],each if Text.Contains([Store Name], " NI") or [Store Number] ="1378" then "Stores NI" else [Customer Group Description],Replacer.ReplaceText,{"Customer Group Description"})

Justas4478's avatar
Justas4478
Post Prodigy
1 year ago

SamWiseOwl I think I manage to find solution in M code:
Table.ReplaceValue(#"Renamed Columns1",each [Customer Group Description],each if Text.Contains([Store Name], " NI") or [Store Number] ="1378" then "Stores NI" else [Customer Group Description],Replacer.ReplaceText,{"Customer Group Description"})

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Justas4478 , hello all, thank you for your prompr reply!

I'm glad to hear you found a solution and thank you for sharing it.

 

Please remember to accept your solution as answer.

 

It will do great help to those who meet the similar question in this forum.

 

Thanks again for your contribution.