Change formulas to point to another table - in bulk

[Anonymous]

I have a table that has about 100 DAX measures pointing to it.  I recently had to change the scope of the source data so it was uploaded under a new table name.  The fields in the original table also exist in the new table so I'd like to change the dax formulas to point to the new table.

So, for example, I'd like to change this

SUM('GSD DSR Summary Data'[% Call/Chat Abandon Rate])

to this

SUM('GSD Data'[% Call/Chat Abandon Rate])

Is there a way to do this in bulk (all the formulas at once) or do I have to change each one individually?

[Anonymous · Accepted solution]

HI TAMERJ!!!!!!!!!!!

I will and THANK YOU again for your help a few weeks ago.  You're still my hero!

[tamerj1]

Hi @Anonymous 

try to first change the table manually from the pbi file (rename the table itsef) then update the data.