DAX to return a column that has multiple filter criteria and multiple tables

[sivarajan21]

Hi Good Day,

I have a proper data set that involves three tables viz,

1)DataInvoice

2)Points

3)Factor

I need a visual that shows Date column from Datainvoice,units column from datainvoice table multiplied with value column from Factor table.  

But the above can happen with few filter criteria as below

1)Date column from Datainvoice should fall between Start and End date of factor table and then return corresponding Value

column

2)while filtering the above we should make sure that DBName-point-id from datainvoice should match DBName-point-id of

points table which inturn looks for DBName-Utility in factor table and picks up the VALUE column

This is how the relationship looks:

I want the output to look like below in a visual

File Portfolio performance 

Looking forware to your response

Thanks in advance

@amitchandak 

@Ashish_Mathur 

@Greg 

@FreemanZ 

@Greg_Deckler