Forum Discussion
Solved
Adding a table multiple times to the same dataset
I need a way to query data from one common table multiple times, looking for different results. Yes, I could use a subreport, but for other reasons, it won't help. Here's a example of what it is I'm ...
Hi!
I figured it out on my own. I tripped over the LOOKUP function and played around with it. I was able to use it to solve my problem. Thanks all for your help!
Kevin
Hi!
I'm a little confused by your question as the data is coming from an SQL DB. The issue with 4 datasets is that I cannot combine data from different datesets into one common table of results, thus why I am stuck.
Please let me know if I missed something!
Thanks, Kevin
If you have the data in SQL then it may be easiest to use a SQL query to structure your data first, so you could build it into one query and use this in power bi.
You can also merge queries in power query to combine multiple datasets into one, if you prefer.