Forum Discussion

cerebraino's avatar
cerebraino
Microsoft Employee
3 years ago
Solved

Safely Removing Auto date time created tables

Hello, we have a main dataset serving around 100 reports, regretfully the creators of that dataset initially had "autodate time" setting turned on , which as you knows creates automatically for each ...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    Hi, cerebraino ;

    As far as I know, there is currently no way to automatically remove safely
    Date table;
    A convenient way to do this is to save a copy and then delete the date table to see if the original report was affected? If there is no impact, you can delete the table directly;
    For how to easily identify whether the report is using this table, you can click on each visual and it will display the table corresponding to the field.


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

cerebraino's avatar
cerebraino
Microsoft Employee
3 years ago

Hello I have a follow up / additional question about this, via DAX Studio I have generated a list of all maasures of my model, and out of such I have found all which usde the autodate time tables, my question is can I just remove the .[date] part of such or which considerations should I have in order for the measures to keep working, here's and example

 

CALCULATE(
MIN(factManualOKRandKPIData[Value])+0,
FILTER(factManualOKRandKPIData,
factManualOKRandKPIData[KPIName]="InDiscoveryCapacityLimits"
&& factManualOKRandKPIData[DatathroughDate].[Date]= DATE(YEAR(TODAY()), MONTH(TODAY()), 1)
)
)

 

Can I just delete the .[date] portion? after turning off the auto datetime setting?

 

Thanks

 

Juan