Sum data from 2 unrelated tables (key dates)

[ErickBorgesV4]

I have 2 tables, both have values ​​separated by dates, I need to add these values ​​by the dates shown.
They do not have relationships in common, but are related to the dCalendar table.

I tried to create a new table and use LOOKUPVALUE to generate the 2 values ​​in a table and add them up ,but it still gives an error when the key provided has the date value

I would like to know how can I add both values ​​and separate them by dates

The value highlighted in red would be the value that I must add, the value in blue would be the relations with the dCalendar table

[amitchandak · Accepted solution]

@ErickBorgesV4 , you can join both tables with date table and then display their measure with columns from a common date table

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...