How to "Replace-All" a Date-attribute with another Date-attribute

[Namoh]

Hi, I have a huge issue.

In the past when I started with my Power Bi report I linked a CALENDAR-table (excel).

I've used the DATE-field from this Table in Measures and Graphs.

Apparently this was a Date-table which isn't being updated anymore, and I should have used a DateTable. 

I've inserted the DateTable into my pbix-file and I've created all Relationships with the new DateTable which already existed with the old CALENDAR-table.

I now need to replace the CALENDAR.DATE (only field used currently from the CALENDAR-table) reference in all my Measures, Graphs etc with the DateTable.Date.

Is there an easy way to do this, or is this a manually action (meaning going through all Measures and Graphs one-by-one to change and hope everything shows the same as it does now)?

If possible I would like to do a "Replace-All" CALENDAR.DATE -> DateTable.Date with keeping my Graphs as they're.

Hope someone can help me.

Thanks in advance.

[timg]

Hi Namon,

You can use DAX studio to extract a list of all measures in your model. This could help finding all the references to the old table more easily. However, the actual replacement of those references will still be a manual task as far as I know. Nevertheless, if you're interested in getting the list of measure/formulas you'll find an explanation of how to do so here: How to view and retrieve all measures? - Power BI - Data Bear - Power BI Training and Consulting

[Namoh]

Hi timg, thanks for your reply.

I've used DAX studio and replaced all CALENDAR-table reference with the DateTable reference.

Is there also a way (with DAX studio) to find all attributes used in the filters/visualisations/etc from the CALENDAR-table? 

[timg · Accepted solution]

Hi Namoh,

You could give the Power BI Helper - RADACAD a try. I just tested it and it has an option to export the unused columns/tables from your reports. Below you'll find a reference to the output based on by test file:

Power BI helper optionsOutput

Regards,

Tim

[amitchandak]

@Namoh , Power BI, I doubt there is an easy way. All of them will error if you remove the table.

May be some external tool can help