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, this is my problem
I have 2 Tables "Ventas" and "Reuniones", and my goal is add a column (N° Reunion) in Ventas, i try with Merge Queries, the matching Column beetwen the 2 Tables is "Fecha", the parameter is unique in "Reuniones" and various in "Ventas", but the result at Expand the Merge Queries is only "null",
what it´s wrong? or exist another form to do that?
Regards
Solved! Go to Solution.
While merging select Fecha column join column (This you already know)
Prefer Left Outer same as I did, then expand desired columns
Result will be as below
Let me know if you need sample pbix file
Regards,
Arvind
Hi @andrescaso,
The way as @arvindsingh802 shared should worked well. Could you please share your sample data if that doesn't make sense?
Regards,
Frank
Thanks
The solution work for me,
While merging select Fecha column join column (This you already know)
Prefer Left Outer same as I did, then expand desired columns
Result will be as below
Let me know if you need sample pbix file
Regards,
Arvind
Can you post some sample data here to understand the issue better?
Thanks
Raj
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 |
---|---|
105 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |