Forum Discussion
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...
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"})
If i were you I would be looking to have a stores Dimension table where you can assign the correct NI/UK flag before loading into your model and then join this to your fact table on store number. If this is not possible SamWiseOwl suggestion is probably the way to go however you will have to account for future variations of your search string.