Forum Discussion

kilala's avatar
kilala
Resolver I
2 years ago

DirectQuery - Split into Rows

Hi all,   I know that we cannot implement split into rows in directquery mode, but is there a workaround i can follow?  The examples i found is only split into column, not rows. if anyone can find...
Need Help
Show and Tell
Tips and Tricks
Dangar332's avatar
Dangar332
Resident Rockstar
2 years ago

Hi, kilala 

 

here sample data

 

follow below steps

1.  in home tab click on split column after click  By delimeter

2. click ok and it give you output like below

3. transpose columns it give you answer like below

 

download pbix file click HERE 

refer power query part