Forum Discussion
All fields in one cell in excel
Hi dineshj ,
Can you provide some sample data and expect result?
Maybe you can use power query to split the string in one cell and unpivot them. Some steps like the following.
client requested service a001 service1;service2;service3 a002 physical1;physical2 split column-->
client requested service1 requested service2 requested service3 a001 service1 service2 service3 a002 physical1 physical2 null unpivot -->
client requested service a001 service1 a001 service2 a001 service3 a002 physical1 a002 physical2 Then measure like this:
all services = CONCATENATEX('Table',[service],",")Result:Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi dineshj ,
Can you provide some sample data and expect result?
Maybe you can use power query to split the string in one cell and unpivot them. Some steps like the following.
| client | requested service |
| a001 | service1;service2;service3 |
| a002 | physical1;physical2 |
split column-->
| client | requested service1 | requested service2 | requested service3 |
| a001 | service1 | service2 | service3 |
| a002 | physical1 | physical2 | null |
unpivot -->
| client | requested service |
| a001 | service1 |
| a001 | service2 |
| a001 | service3 |
| a002 | physical1 |
| a002 | physical2 |
Then measure like this:
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.