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 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
Solved! Go to Solution.
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.
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.
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |