Forum Discussion
Split 1 Column to 3 Column based on parent
Hi, I have been looking at a problem that I have and I need to convert one column to multiple columns based on their parent. Here is the data that I have; LinkID Product.Id Product Par...
hi Anonymous
The formula is for calculated column, not custom column in edit queries.
Please download my sample pbix file and see the details in it.
Regards,
Lin
Hi v-lili6-msft
All looking good, I have started to follow your steps but when I am creating the custom column I get the below error;
Thank you for your help
v-lili6-msft
Community Support
Community Supporthi Anonymous
The formula is for calculated column, not custom column in edit queries.
Please download my sample pbix file and see the details in it.
Regards,
Lin
Great, yes I see now thank you very much and it all worked