Do I really need to maintain two separate Date Tables to achieve this

[MK3010]

Hi @Neville,

Yes ou can just maintain one date table and have

1. Active relationship between the date table and Closed Date.
2. Inactive relationship between the date table and Revenue Date.

The active relationship will work as normal but for inactive relationship you need to use USERELATIONSHIP function. Please refer below discussion which has good links describing how to achieve it.

Two fact tables for same dates table

@pedroccamara, If you keep the relationship inactive, you will need to use USERELATIONSHIP in your measures . The alternative is to delete the inactive relationship, and use TREATAS in your measures. Here are some links for each of these. https://info.enterprisedna.co/dax-function-guide/userelationship/ https://info.enterprisedna.co/dax-function-guide/treatas/ Thanks Jarrett

https://info.enterprisedna.co/dax-function-guide/userelationship/