Forum Discussion
Reationship
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!
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
2 Replies
- v-jiascu-msftMicrosoft Employee
Hi iurilino,
Can you share a dummy sample? You can upload it to OneDrive, GoogleDrive then share the download link here.
Best Regards,
Dale
- iurilinoFrequent Visitor
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