Filter tables based on two columns in DirectQuery

[Dario_87]

Hi,

I'm designing a report in DirectQuery with this Tables:

The table ReportScores is the main, linked with Scores and CustomerDetails using "Partita Iva" (Vat Number) as a key.

All of these three tables could be updated with new rows ("Data Aggiornamento" as updating date).

My goal is to link correctly these tables using both "Partita Iva" and "Data Aggiornamento Modello".

If I would filter ReportScores by a date, for example 01 - March, I need that the report upload data from Scores and CustomerDetails where Scores.DataAggiornamento is the 1st <= ReportScores.DataAggiornamentoModello and where CustomerDetails.DataAggiornamento is the 1st <= ReportScores.DataAggiornamentoModello.

Remember that my customer want only DirectQuery mode.

Thank you for supporting.

[Dario_87]

Sorry,

CustomerDatails must provide only the last updated row (for each vat number).

This because the possible relationships must be one:many, one:one or many:one