Forum Discussion

jpt1228's avatar
jpt1228
Icon for Responsive Resident rankResponsive Resident
6 years ago

Changing out DimDate table for a different date table in data model

Hello - I have a DimDate table I created as one of my first date tables in the largest data model I have. I have a new DimDate table I want to replace it with. The original (current) DimDate table wa...
Tips and Tricks
v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi jpt1228 

 

You might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive or dropbox and share the link to the file. Please do not forget to describe the expected results based on this sample data.

 

jpt1228's avatar
jpt1228
Icon for Responsive Resident rankResponsive Resident
6 years ago

Hello v-diye-msft  The process I am following currently is to create the new M code DimDate table and naming it DimDatee. Ensuring all similar columns are the same name such as Week in year = WeekNum. Copying all custom calculations for dates into the DimDatee table and then deleting the DimDate table. From there I rename the DimDatee DimDate and need to re-connect all the tables. The final step is to go back through all the time based visuals and re-do anything that broke.