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 date? Thx
If the below meets your requirement, I will post the PBIX file which has the transformation steps
6 Replies
- Manoj_NairSolution Supplier
- FrancoisRiekRegular 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_NairSolution Supplier
If the below meets your requirement, I will post the PBIX file which has the transformation steps