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"})

SamWiseOwl's avatar
SamWiseOwl
Super User
1 year ago

Hi Justas4478 

You could creater a Calculated Column in the Table view:
Location =
If( 

CONTAINSSTRING([Store Name], " NI") , "NI", "UK")
  • Justas4478's avatar
    Justas4478
    Post Prodigy
    1 year ago

    SamWiseOwl Is this going to as well check other versions of NI for example:
    'Ni', 'ni' or if they appear inside store names like this, 'Keniworth'?
    Since these are my concerns if they will get considered as part of 'NI' group.

    • SamWiseOwl's avatar
      SamWiseOwl
      Super User
      1 year ago

      It isn't case sensitive.

      Note I put " NI" the space infront means it can't be in Keniworth as it won't have a space in front of it.

       

      • Justas4478's avatar
        Justas4478
        Post Prodigy
        1 year ago

        SamWiseOwl I think it could work but I am not sure how it integrates with other groupings.
        Here is full list of groupings:

        Beause of that it might have to be M code solution.