The result of your transforms must have the same structure. If your column sometimes splits into two, and sometimes into three columns you will get an error message .
Better to use DAX if you need to act on the content inside the column.
Helpful resources
Announcements
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
