Forum Discussion
andyspa
Helper I
Helper Isemicolon Country field
Hello everybody! I have the following issue.. the dataset contains in each row a project. The filed country is populated with more than one, separated by semicolon. I also have a field with the r...
andyspa , You need to create custom column in power query
I tried , this is the custom column in power query before you split to divide the amount
= List.Count(Text.Split([Users],","))
amitchandak
Super User
Super Userandyspa , You need to create custom column in power query
I tried , this is the custom column in power query before you split to divide the amount
= List.Count(Text.Split([Users],","))
andyspaHelper I
Helper Ithanks. so i created that custom column (what's "users" in brackets?). Then I split and then create another custom column with the division?