Forum Discussion

vsolanon's avatar
vsolanon
Frequent Visitor
6 years ago
Solved

Merge Queries is not populating the information for 3 Queries

Hi Experts!   I am creating my first Dashbord combining 3 SharePoint lists. My main issue is that when I try to merge  the third Query, the new Query created  is not populating any information. Ki...
Need Help
Show and Tell
  • dax's avatar
    dax
    6 years ago

    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 Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

I think this would be easier if you pasted the text from the Advanced Editor ImkeF , edhans 

vsolanon's avatar
vsolanon
Frequent Visitor
6 years ago

Hi Greg_Deckler the formula used is:   Table.Column([MyTable], "RotationDates")

Please let me know if any further information is required,

Thanks! 🙂