Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Split row in powerbi

I have a flag column "COMP",

Need to break it on basis of 2 conditions 

I have 2 columns in my table 1 is flag & another is product

if flag is comp then i need to split it in 2 rows 1 condition is product + od and other is product+tp else product only

 

 

 

for eg 

new column  = IF(table[Flag] = "COMP", table[Product] & "" & "OD",
IF(table[Flag] = "COMP", table[Product] & "" & "TP",table[Product]) )

 

I'm using dax but its only givind product + od not product tp 

 

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    You are using 

     

     IF(table[Flag] = "COMP"

     

    twice. That means the second time it will be ignored. Please provide sanitized sample data in usable format (not as a picture - inserting it into a table would be good) and show the expected outcome.