You have a Power BI data model that imports a date table and a sales...

Renaming the date table and creating calculated tables for "Order Date" and "Delivery Date" with DAX expressions would not fully meet the goal. Power BI only allows one active relationship between two tables at a time. Therefore, you cannot have active relationships between the sales table and all three date tables simultaneously.

Instead, you would typically create one active relationship (e.g., with "Order Date") and use DAX functions like USERELATIONSHIP to switch between different relationships when needed for analysis. Alternatively, you could use a single date table and create multiple relationships, using inactive relationships and the USERELATIONSHIP function to activate them in specific measures.