Measures with different dates

[kg4u]

Hey PBI Community,

I need some help.  I do not know how to create 1 measure which uses a specific date and then create 2 measures using a different date.  At the fundamental level I created 2 calendars, and the data results were correct when I used both calendars, however, now I can't figure out how to use the calendars to display the data.  I think I need some more complex measures. Do you have any ideas on how to resolve my problem? 

My measures are very simple.

Total Applications = SUM('Fact Data'[Applications])

Total Policies = SUM('Fact Data'[Policies])

Total Sales = SUM('Fact Data'[Original Sales])

Applications needs to use the Entry Date column, highlighted with the red box. 

Policies and Sales need to use the Conversion Date column, highlighted with the red box. 

Here is a snip of the Fact Data

How can I sum Applications using Entry Date?

How can I sum Policies and Sales using Conversion Date?

Thank you!

[nandic · Accepted solution]

@kg4u , you should use combination of Calculate and UseRelationship functions.
Use 1 calendar table and then using these functions define which metrics uses which date column for calculation.
Link: https://www.sqlbi.com/articles/using-userelationship-in-dax/

Cheers,
Nemanja

[kg4u · Accepted solution]

Your solution worked perfectly for what I needed, thank you!

[nandic · Accepted solution]

@kg4u , you should use combination of Calculate and UseRelationship functions.
Use 1 calendar table and then using these functions define which metrics uses which date column for calculation.
Link: https://www.sqlbi.com/articles/using-userelationship-in-dax/

Cheers,
Nemanja