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 sim...
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....

     

     

     

     

     

     

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

Otravus - how do I do that? 

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

I have found a workaround. Thanks

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

    Hi chakrabmonoj，

    Could you share your workaround and mark it as answer? So other people can find solution easily.

    Best Regards,
    Angelia

    • chakrabmonoj's avatar
      chakrabmonoj
      Icon for Helper II rankHelper II
      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....

       

       

       

       

       

       

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

        Hi chakrabmonoj,

        Your workaround is perfect, please mark it as answer, which will help more people.

        Best Regards,
        Angelia