Forum Discussion

andyspa's avatar
andyspa
Icon for Helper I rankHelper I
5 years ago
Solved

semicolon 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...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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],","))

  • andyspa's avatar
    andyspa
    Icon for Helper I rankHelper I
    5 years ago

    Hello amitchandak and thanks for your suggestion. I didn't know i could split clumns into rows! AWESOME!

     

    Regarding the formula, I get the error "Token Eof expected".. 

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      5 years ago

      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],","))

      • andyspa's avatar
        andyspa
        Icon for Helper I rankHelper I
        5 years ago

        thanks. so i created that custom column (what's "users" in brackets?). Then I split and then create another custom column with the division?