Forum Discussion

NB68841's avatar
NB68841
Advocate I
8 years ago
Solved

Combine data from different dataset

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

Need Help
  • ricardocamargos's avatar
    ricardocamargos
    8 years ago

    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

1 Reply

  • ricardocamargos's avatar
    ricardocamargos
    Continued Contributor
    8 years ago

    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