Measure that calculates based on 2 different date columns

[nckpedersen]

ok, here's my big problem: I need to make calculations based on two different time horizons and those need to coincide with the same table. As you can see, the table on the left represents revenue projections and actuals based on _2024[Date] which is related to 'Line Item Schedule'[Schedule Date]. The table on the right uses 'Opportunity Product'[CreatedDate] as the time basis. The problem arises because only successful opportunities appear on the Schedule table so it cannot count in either direction. I need MQL actual to calculate in the left table as it does in the right table

For some reason, USERELATIONSHIP won't work when i set up a direct relationship with _2024[Date] and 'Opportunity Product'[CreatedDate]

 

 

[amitchandak]

@nckpedersen , I do not see, two join between two tables like date and opportunity. So Userelationship is not an option.

If relationships are inactive because of loops or multiple paths, they can not become active using Use relationship.

I can see, many bidirectional joins, Make them single-directional and try to activate inactive joins

Example of userelationship

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU