Create a measure despite the table joins

[François]

I have this model :

DATE --> ACTIVITIES

We use the date table to apply a filter on the start date of all activities.

My problem is that I need to also calculated the schedule activities, which have NO start date, I need to use another date column (scheduleddate). So the table link is excluding them all from the calculation, and I have get a null result. 

Is there anyway to do the calculation, without keeping the date constraint ? Thanks !

[v-juanli-msft]

Hi @François

"So the table link is excluding them all from the calculation, and I have get a null result. " 

I don't understand this, could you clear me?

do you want this output?

Best Regards

Maggie

[François]

Hi Maggie

Almost that. We have a date in one of the two columns actually. So the solution provided here is good, we test which column is filled and use the value in a next column that can be used to link the date table. 

[Anonymous]

Hi @François,

You could create a calculate column in Activities table:

MyDate =
IF (
    ACTIVITIES[StartDate] = BLANK (),
    ACTIVITIES[scheduleddate],
    ACTIVITIES[StartDate]
)

Then you can connect date table to activities table by MyDate.

Chiara

[François]

Hi Chiara, yes, i thought that it could be possible indeed, that's a confirmation. I was wondering if it was possible with a function in the measure maybe. But I can definitely try this solution otherwise, thank you !