Forum Discussion
Fill a column based on a value in another column
Hello, I have a xml document into a column and I would like to send some specific information into a new columnFor Example, imagine that my parent node contain a company name and the the child node contains the adress and the other child node contains the number of employees into this company.Then my question is how can we use dax to put the company name into column1, adress into column2 and the number of employees into column3.I cannot use expand because, some rows contains the word table, some rows shows values and other row contains the null valueThanks in advance for your help
7 Replies
- PattemManohar
Community Champion
Anonymous Could you please post some sample data in copiable format and expected output which will help to provide an accurate solution.
v-piga-msftResident Rockstar
Hi Anonymous ,
You could post your sample data with table format that will be help us understand your scenario better.
Best Regards,
Cherry
- v-piga-msft
Hi Anonymous ,
You could copy your data and paste here.
In addition, you also could upload your data sample in Onedrive and post link here.
Best Regards,
Cherry
- v-piga-msft
Hi Anonymous ,
More details could help us understand your scenario better.
If it is convenient, could you share your sample data and your desired output so that we could help further on it.
Reference: how to get your question quickly
Best Regards,
Cherry
