USEREALTIONSHIP convert to date in VAR

[Syndicate_Admin]

Hello everyone

I have a calendar table date column that I'm trying to connect to my main table with an arrival date column. However, the arrival date is in date and time format.

The question is: How can I convert the arrival date to use userelationship in my measure without creating a new date-only column?

[Anonymous · Accepted solution]

Hi, @Syndicate_Admin 

Thanks for the reply from @PhilipTreacy .

I create a sample table:

First, create an inactive relationship between the two tables.

Then create a DAX measure, and use the USEREALTIONSHIP function to specify the inactive relationship.

ShipDate_RM3 = CALCULATE(
    SUM('Table'[Quantity]),
    USERELATIONSHIP('Date'[Date], 'Table'[Arrival Date]),
    FILTER('Table', 'Table'[Source] = "RM3")
)

Here is my preview:

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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

[PhilipTreacy]

Hi @Syndicate_Admin  @golire 

What exactly are you trying to do?

You don't need to create a new date column from the date/time to use it in measures.  You could just use functions like YEAR, MONTH and DAY with DATE to create a date.

The answer depends on what it is you want to do.

Phil