muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,089
- Office Version
- 365
- 2021
- Platform
- Windows
hi all..
how to split data using Power BI (Desktop) with criteria:
split data after mark (/) slash
here my sample
anyone help, thank in advance
susant
how to split data using Power BI (Desktop) with criteria:
split data after mark (/) slash
here my sample
original data | split1 | split2 | spit3 | split3 | split4 |
Text AAA/Mango/1. Tim Kerja/1b | Text AAA | Mango | 1. Tim Kerja | 1b | |
Text AAA/Mango | Text AAA | Mango | |||
Text AAA/Mango/2. xxx | Text AAA | Mango | 2.xxx | ||
Text AAA/Mango/2. xxx/2a | Text AAA | Mango | 2.xxx | 2a | |
Text AAA/Mango/3. YYY/3a/ok | Text AAA | Mango | 3.YYY | 3a | ok |
anyone help, thank in advance
susant