Forum Discussion
Merge Queries is not populating the information for 3 Queries
Hi vsolanon ,
According to your description, which step will cause abve error? Did you click the error to see the detailed error information? If you want to use M code in your last step, you don't need to expand the list("Total Rotation Dates"). Or you could expand it like below. You could try it to see whether it work or not
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi edhans the M Code of the last step I applied is:
= Table.TransformColumns(#"Removed Columns1", {"Total Rotation Dates", each Text.Combine(List.Transform(_, Text.From), " , "), type text})
Community SupportHi vsolanon ,
According to your description, which step will cause abve error? Did you click the error to see the detailed error information? If you want to use M code in your last step, you don't need to expand the list("Total Rotation Dates"). Or you could expand it like below. You could try it to see whether it work or not
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi edhans dax dax thank you both for the suggestions!
Kindly note I follow your recommendations and noticed the error was becauase the "IDRotation" column was not in Text Format. After updating the "IDRotation" column in both Queries, I was able to merged them and create a new query with the information combined.
I am new in PowerBi and just learn new things each day 🙂
Thank you!
- edhans
Community Champion
Great. Data types are critical and can cause all sorts of issues if not set up properly, especially for merges and relationships in the model.
