Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, I'm sorry for my bad English beforehand, the following happens: I have two tables ('DUPLICATAS [Centro]', 'ESTMOVIMENTO [CODCCU]') that are linked by the CENTRO table [Code], I need the summation per month of ' DUPLICATAS [Center] 'and' ESTMOVIMENTO [CODCCU] ', only that there are some values that are in' ESTMOVIMENTO [CODCCU] 'that are not in' DUPLICATAS [Center] ', when I bring the filtered somátorio per month of ESTMOVIMENTO, brings the overall sum of DUPLICATAS in the year by month, and not only per month. I have already tried using tb. Follow the pictures as an illustration and with the relationship made. Remembering what I'm doing with the CODCCU filter = 207007.
Thanks!
Solved! Go to Solution.
Hi @v-jiascu-msft,
Thanks for answer me man, but i have already solved, follow the link to solution, if have someone with the same problem: https://community.powerbi.com/t5/Desktop/Union-two-tables-with-different-columns-names/td-p/141153
Hi @iurilino,
Can you share a dummy sample? You can upload it to OneDrive, GoogleDrive then share the download link here.
Best Regards,
Dale
Hi @v-jiascu-msft,
Thanks for answer me man, but i have already solved, follow the link to solution, if have someone with the same problem: https://community.powerbi.com/t5/Desktop/Union-two-tables-with-different-columns-names/td-p/141153
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |