Do I need to create a separate Date Table for each Date field?

[VinhTon]

If I need to do calculate functions that depend on both order date and delivery date, do I need to create two separate date tables and link them independently?

https://www.youtube.com/watch?v=-li7sxUxEqA

[Anonymous]

Hi @VinhTon ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.

Best Regards,
Stephen Tao

[VinhTon]

sorry about that, done

[Anonymous]

Hi @VinhTon ,

Another workaround is to unpivot the two columns in the Power Query Editor.

Here's an example,

Select the two date columns and then click 'Unpivot Columns'.

Then you could get a date column and a attribute column.

You can check more details from my attachment.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PC2790 · Accepted solution]

Hey @VinhTon ,

You can use the same Date Table and create an active and inactive relationship between two tables- one between Date and Delivery date and other one between Date and Order Date.

This concept is called Role Playing Dimension

And in the scenarios where you need to enable the inactive relationship,use USERELATIONSHIP dax