Combine data from different dataset

[NB68841]

Hi,

  I have created 4 different reports with detail information (say R1, R2, R3, R4) and different datasets. My requirement is to build summary or table (say S1) which will pull the numbers from R1,R2,R3 & R4. Can you please let me know whether we can create a report which will show summary data from 4 different reports.

Thanks,

Ranjjeet K

[ricardocamargos · Accepted solution]

Hi @NB68841,

You can use the function "Append Queries" in Query Editor or create a new table using the Union function in DAX.

I think in Query Editor is easier than DAX in this case.

Thanks,

Ricardo