Forum Discussion
Adding a date column (that has multiple values) from another table
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...
I ended up using this solution (the Way 2 version) and it worked perfectly.
Create an inactive relationship Flu_RMA's "Last Ship Date" and your date table, then you can use the function
USERELATIONSHIP
I have a similar issue,
Sum of Workshops = CALCULATE(COUNT('1:1s'[WorkshopStatus]),USERELATIONSHIP('Date'[Date],'1:1s'[WordshopDate])) works a treat for me.
I ended up using this solution (the Way 2 version) and it worked perfectly.
Good to hear man, Please ensure you mark the solution as accepted.