Two dates different on table columns

Hello mmramo,

Yes, it's possible to relate two different date columns from different tables in a single visual panel.

The USERELATIONSHIP function is the correct approach to create a relationship between these columns. If it's not working as expected, there might be a few reasons to investigate:

1. Check Column Data Types: Make sure that the data types of the columns you're trying to relate are the same. The columns you're trying to relate should both be of type 'Date'.

2. Direction of Relationship: The USERELATIONSHIP function allows you to specify a relationship between columns that are not directly related in the model. However, it's important to understand the direction of the relationship.

USERELATIONSHIP(TableA[Date A], TableB[Date B])

• Check Filter Context: Sometimes, issues can arise if there are other filters or slicers in your report that interfere with the relationship you're trying to set. Clear all filters and slicers and try setting up the relationship again.

• Bi-Directional Filtering: If your tables have a bi-directional relationship (both tables can filter each other), the USERELATIONSHIP function might not be necessary. Power BI will automatically use the appropriate relationship based on the context.

• Refresh Relationships: If you've recently added the USERELATIONSHIP function, make sure to refresh your data model to apply the new relationship.

Should you require further assistance, please do not hesitate to reach out to me.