Forum Discussion
Dynamically Merge Tables Based on Parameter
Hi, I'm currently taking a PDF order sheet and 'converting' it into a standard format "PDFQuery1" then I merge that into "LoadQuery" that is checking our ERP system for stock, jobs, delvieries e...
Hi Anonymous ,
The dynamic table name might help you, please kindly refer to
Solved: Dynamic source table name in Power Query - Microsoft Power BI Community
Source = Expression.Evaluate("Table" & parameter, #shared)
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the heads up. I haven't been able to get it working today but I'll keep going at it and try to work out where i'm gonig wrong and mark as resovled if/when i get there.
Funnily enough last night I went down the 'if' statement route as a slightly better workaround so good to see I wasn't the only person to try that 🙂