2 Dates to one calendar

[colourfullife]

Hi,

I'd like to get some help.!

I want to make more than 2 active relationship.

here is my report, 2 dates columns and one calendor that created with dax calendarauto().

at the end, i want to show 2 dates columns progress in one graph.

at the moment, one relationship is active and in the graph it count same figures which is wrong..

any advice would be much appreciated..

thank you,

CL

[v-jayw-msft]

Hi @colourfullife,

In you scenario, USERELATIONSHIP() function might be helpful for you.
Here’s my sample data:

Please check following steps as below and see if the result achieve your expectation:

1. Create inactive relationship:

2. Create measure:

Measure = CALCULATE(COUNT('Table'[end]),USERELATIONSHIP('Table'[end],'Table 2'[Date]))

3. Result would be shown as below:

Hopefully works for you.

Best Regards,

Jay

Community Support Team _ Jay Wang

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