Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |