Reationship

[iurilino]

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.

https://ibb.co/gdKXF9

https://ibb.co/hGiba9

Thanks!

[v-jiascu-msft]

Hi @iurilino,

Can you share a dummy sample? You can upload it to OneDrive, GoogleDrive then share the download link here.

Best Regards,

Dale

[iurilino · Accepted 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