Adding a date column (that has multiple values) from another table

[Anonymous]

Hello, 

Date table is in top left of image below.   

In the Flu_RMAs table there is a field called  "Last Ship Date".     It is not connected to the date table in any way  (there is another more relevant date field connected to the date table).  

However, I have a situation where I need to use the Last Ship Date field, but I actually need to use with respect to the table next to it called RMA Line Items.   (essentially the Flu_RMAs table contains header data....and the RMA Line items contains line item data).   

There is no direct relationship between those two table, but both are connected to a dimension table called RMA ID.   (an RMA is essentially an order ID number place for returned merchandised).   

I had tried using the LOOKUPVALUE, but because the Last Ship Date field does not contain unique values, it did not work.   

Any ideas how I can get the Last Ship Date field in my RMA Line Items table?  

[Anonymous]

Create an inactive relationship Flu_RMA's "Last Ship Date" and your date table, then you can use the function 

USERELATIONSHIP 

https://docs.microsoft.com/en-us/dax/userelationship-function-dax#:~:text=USERELATIONSHIP%20uses%20e... 

https://www.youtube.com/watch?v=hcUJWmo-8mM 

I have a similar issue, 

Sum of Workshops = CALCULATE(COUNT('1:1s'[WorkshopStatus]),USERELATIONSHIP('Date'[Date],'1:1s'[WordshopDate])) works a treat for me. 

[Anonymous · Accepted solution]

I ended up using this solution (the Way 2 version) and it worked perfectly.  

https://community.powerbi.com/t5/Desktop/Using-DATEDIFF-Between-2-Tables-with-an-Inactive-Relationsh...

[Anonymous]

Good to hear man, Please ensure you mark the solution as accepted.