cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chakrabmonoj Regular Visitor
Regular Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
chakrabmonoj Regular Visitor
Regular Visitor

Re: can the same calculated table be used in different reports

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

 

 

BI new table existing calculated table.JPG

 

 

 

 

View solution in original post

9 REPLIES 9
v-huizhn-msft Super Contributor
Super Contributor

Re: can the same calculated table be used in different reports

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 Regular Visitor
Regular Visitor

Re: can the same calculated table be used in different reports

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

 

this is what I have :

pbix screen shot.jpg

 

 

 

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 Super Contributor
Super Contributor

Re: can the same calculated table be used in different reports

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

otravers Member
Member

Re: can the same calculated table be used in different reports

Couldn't this be done with the PowerApps Common Data Service?

chakrabmonoj Regular Visitor
Regular Visitor

Re: can the same calculated table be used in different reports

Otravus - how do I do that? 

Highlighted
chakrabmonoj Regular Visitor
Regular Visitor

Re: can the same calculated table be used in different reports

I have found a workaround. Thanks

v-huizhn-msft Super Contributor
Super Contributor

Re: can the same calculated table be used in different reports

Hi @chakrabmonoj

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

Best Regards,
Angelia

chakrabmonoj Regular Visitor
Regular Visitor

Re: can the same calculated table be used in different reports

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

 

 

BI new table existing calculated table.JPG

 

 

 

 

View solution in original post

v-huizhn-msft Super Contributor
Super Contributor

Re: can the same calculated table be used in different reports

Hi @chakrabmonoj,

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

Best Regards,
Angelia

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 274 members 2,773 guests
Please welcome our newest community members: