Import Text file to PBI how to manually set certain column number for Cost Qty ?

[Paulyeo11]

Hi All

[amitchandak]

@Paulyeo11 , I think there is some problem with a delimiter. Can share a sample.

If there are two delimiters then you can split after import.

Use split into colum in power query

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.

[Paulyeo11]

Hi Amit

Thank you for sharing , below is my TXT sales order raw data file :-

https://www.dropbox.com/s/w23ref7ahm8dds6/SO_TS_Amit.txt?dl=0

Paul

[v-diye-msft · Accepted solution]

Hi @Paulyeo11 

Please find the cleaned file attached.

[Paulyeo11]

Hi Sir

Can you share with me how you do it ?

Paul