Sum Based on Conditional Values from Another Table Columns

[JMSNYC]

Hi.

I cannot figure out how to sum column C from Table 1 based on the condition that column B values fit the interval (Column I and J)

Could anyone help me solve that problem? Everytime I try to either create a new column or a new measure, DAX does not allow me to use the variables I need to implement the maths. 

Thank you in advance

[amitchandak]

@JMSNYC , Try a new column like this Tenders Table

sumx(filter(DailyRevenue, Tenders[TenderStartDate]<=DailyRevenue[DateRev] 
		&& Tenders[TenderEndtDate]>=DailyRevenue[DateRev] && DailyRevenue[CustomerUID] = Tenders[CustomerUID]),DailyRevenue[Revenue])

[Greg_Deckler · Accepted solution]

@JMSNYC - Should be as a column:

Actual Revenue = SUMX(FILTER(RELATEDTABLE('DAILY REVENUES'),[Date Rev.]>=[Tender Start Date] && [Date Rev.]<=[Tender End Date]),[Revenue])

If that does not work please @ me

I did confirm this in the attached PBIX file below sig. Table (23), Table (23a), Table (23b)