Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
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 ...
dataset
report builder
same table
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous 

 

For your needs, the easiest way to implement should be to connect the model in the desktop first, then create the relationship, and the corresponding table, then copy the query to the report builder.

You can patiently check the following documents, which are very detailed:

Reference:

Create a paginated report with a Power BI shared dataset - Power BI Report Builder - Power BI | Microsoft Docs

Solved: Paginated report - nested tables with different da... - Microsoft Power BI Community

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

 

Best Regards,
Community Support Team _ Janey

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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