Forum Discussion
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 add a new table called all incident which is a add on version on rawdata(contains same information and column name as raw data with few more additional column).
I need to delete the raw data table and import all incidents table to the report but it should not crash my visuals and measure.
steps i know to do : copied the measure in raw data to allincidents and renameing the allincident to raw data and add to report and make few other changes were required but it takes me lot of time to complete.
Do we have any other option to have this done in simplier way......
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.
2 Replies
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.
Kudos!!!,This works
Anonymous wrote: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 add a new table called all incident which is a add on version on rawdata(contains same information and column name as raw data with few more additional column).
I need to delete the raw data table and import all incidents table to the report but it should not crash my visuals and measure.
steps i know to do : copied the measure in raw data to allincidents and renameing the allincident to raw data and add to report and make few other changes were required but it takes me lot of time to complete.
Do we have any other option to have this done in simplier way......