Forum Discussion
Customer group split based on stores
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 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.
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.
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.
Hi Justas4478
Could you not add this new column into the slicer.
They can then expand the Stores UK & NI and tick which they wanted.
SamWiseOwl If I understand correctly is it not going to group all the aother stores under UK group from other customer groups?