Forum Discussion
Relationship between tables
Hi everyone, I'm having a relationship doubt.
I need to filter data in GDP table and return values from INTERFACE table
Table GDP
Table INTERFACE
I need to filter from the date of the GDP table (MES_PSTO_CALC) on 01/07 and bring the value 5,555.00 from the Interface table
RESULT
I leave the example of the file below:
I could do this within the power query merging the tables but I'm using DIRECTQUERY with sql and oracle tables and it's not working because it has blank spaces and with trim (text.trim) it's not allowing
tks for help me
Hi Spotto ,
Make the original relationship inactive, and then create relationship based on Dates field instead:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Spotto ,
Make the original relationship inactive, and then create relationship based on Dates field instead:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.