Forum Discussion

chakrabmonoj's avatar
chakrabmonoj
Icon for Helper II rankHelper II
9 years ago
Solved

can the same calculated table be used in different reports

I have one calculated "dates"table in one BI report. But I need to use the same 'dates'table in another BI report and with a different file. Can that be done and if yes, how? 

I have to generate similar reports for 4 different countries and if I can use the same calculated table across the different BI reports, without generating one for each, it will save me a lot of time

thanks

Need Help
  • chakrabmonoj's avatar
    chakrabmonoj
    9 years ago

    My workaround is as follows :

     

    1. Pull in the new query/table (brunei_P7)

    2. Re-relate the "calculated table" to this new query (earlier the "dates" table was related to "table1")

    3. Update all measures written in the earlier table or the calculated table, with the new table name (all measures written with "table1" as reference, now updated to "brunei_p7"

     

    and it works....

     

     

     

     

     

     

9 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi chakrabmonoj,

    Your resource table is same, and you want to create a different file, right? If it is, you should load the resource table, and create different in the same .pbix file. If you want to use the same measure and report for different resouce table and create different reports, we are unable to achieve it.

     

    If you have any issue, please feel free to ask.

     

    Best Regards,
    Angelia

    • chakrabmonoj's avatar
      chakrabmonoj
      Icon for Helper II rankHelper II
      9 years ago

      I want to use the table in a separte/different .pbix file/report - is that possible?

       

      this is what I have :

       

       

       

      i want to use the 'dates' table in a different .pbix file/report, without creating the same table again - is that possible?

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        Hi chakrabmonoj,

        If the report is in same .pbix file, you can use the dates field. If they locate in different file, we are unable to achieve it. Thanks for understanding.

         

        Best Regards,
        Angelia