Forum Discussion
FrancoisRiek
3 years agoRegular Visitor
Column Splitting
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 dat...
- 3 years ago
If the below meets your requirement, I will post the PBIX file which has the transformation steps
- 3 years ago
Manoj_Nair
3 years agoSolution Supplier
FrancoisRiek
3 years agoRegular Visitor
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_Nair3 years agoSolution Supplier
If the below meets your requirement, I will post the PBIX file which has the transformation steps
- FrancoisRiek3 years agoRegular Visitor
Hi Manoj, this is the exact solution, will you pse post the PBIX File?
- Manoj_Nair3 years agoSolution Supplier