Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Delete the source table and add a new table

Hi Team, I have a report with multiple page created with various measure by using the tables below.   Here we use raw data as a main table and it has some measure in it. Now our goal is to a...
Need Help
Tips and Tricks
  • Smalfly's avatar
    Smalfly
    4 years ago

    Hi Anonymous ,

     

    the easiest way to do this is by using the advanced editor. So after chossing 'Transform data' and selecting the raw data table, open the advanced editor

     

    This opens an M script that you can easily replace by the script that you created to load the all incidents table.

    This will keep all existing measures already created on the table and all links with other tables and will hence save you a lot of copy-paste work.

Smalfly's avatar
Smalfly
Responsive Resident
4 years ago

Hi Anonymous ,

 

the easiest way to do this is by using the advanced editor. So after chossing 'Transform data' and selecting the raw data table, open the advanced editor

 

This opens an M script that you can easily replace by the script that you created to load the all incidents table.

This will keep all existing measures already created on the table and all links with other tables and will hence save you a lot of copy-paste work.