Rename table without killing everything

Hi richardmayo 

As tested, if i create a date table via Modeling->New Table, enter DAX formula below:

date = ADDCOLUMNS(CALENDARAUTO(),"year",YEAR([Date]),"month",MONTH([Date]),"week",WEEKNUM([Date],2))

Add [Date] column from "date" table to the visual, then i rename the [Date] as [ss] or rename the "date" table' name, the visual would not break, it shows normally as before.

It is still working for measures which use columns from date table.

If i create a date table via Edit Queries->New blank query,

then i get a table called "new query", the date column is called "Column1",

Close&&Apply to the report view, i add the "Column1" into the line chart,

then i go back to Edit queries, double click on the "Column1" header and rename it as "Date",

rename "new query" as "date table2",

close&&apply, return to report view, chart works smoothly as before.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.