Column Splitting

[FrancoisRiek]

My column has account references for instance (1000/001; 1001/001) and dates for instance (23/03/2022, 01/04/2022).  How do I split it in two columns, one for account references and the other for date?  Thx

[Manoj_Nair · Accepted solution]

@FrancoisRiek 

If the below meets your requirement, I will post the PBIX file which has the transformation steps

[Manoj_Nair]

@FrancoisRiek 

[FrancoisRiek]

Hi Manoj

See below as an example, I need to split the column into two columns, one for Account Ref and one for date,

1000/001

23/03/2022

24/03/2002

1001/001

02/04/2022

Thx

[Manoj_Nair · Accepted solution]

@FrancoisRiek 

If the below meets your requirement, I will post the PBIX file which has the transformation steps

[FrancoisRiek]

Hi Manoj, this is the exact solution, will you pse post the PBIX File? 

[Manoj_Nair · Accepted solution]

@FrancoisRiek 

I am attaching the PBIX file.

If you face any issues understanding it just let me know

[FrancoisRiek]

Hi Manoj, Thx so much for your assistance!