Forum Discussion

Mtaberna's avatar
Mtaberna
Frequent Visitor
4 years ago

split column by "|" NOT in Power Bi Query

Hi, I neet to split this column (1-PATH col)  in  n columns by a delimitator  ( | ) I know this can be easily made with power query but the column is a measure     First row result should b...
Need Help
  • Mtaberna's avatar
    Mtaberna
    Frequent Visitor
    4 years ago

    Hi, thanks for your response.

    The thing is that the proposed solutions work for just 2 columns.

    I have a max of 9 columns, delimited by this character =  |

     

    I need DAX code to split everything inside the column and also consider the case where 1 , 2 or more columns could be empty

     

    New Ideas ?

     

    Thnks

    • Mtaberna's avatar
      Mtaberna
      Frequent Visitor
      4 years ago

      Hi Liu

      That worked fine.. in a new table......but is there any other way to create the COLUMNS in the same Original Table  ??

      The thing is......I need everything in one table

      Thanks