Create dax that sum two columns of values with a different tables

[dolevh]

Hey Everyone,
I want to create Dax that sums two columns of values with different tables per month.
For example: Table a [Total Hours per Month] + Table B [ Valid Hours] on Jan / Feb / March until December.

[dolevh]

Thanks!
but, I'm looking some option without to create date table.

[ryan_mayu]

@dolevh 

what do you mean by looking for DAX?

What I provided is a DAX solution. 

So you don't want to create a date table?

[dolevh]

Yes 🙂

[ryan_mayu]

@dolevh 

sry, I have no idea why after I clicked post, the message disappears and I accepted my answer as a solution.

since I only can see one part of your whole data, not sure if the solution works.

It looks like you only have the first date of every month and not sure if you have duplicated date or not.

TableA

TableB

create a relationship between two tables and create a column

Column = SUMX(RELATEDTABLE('Table B'),'Table B'[value])+TableA[value]

[ryan_mayu · Accepted solution]

@dolevh 

you can create a date table and create relationships with both tables.

measure= sum(total hours per month)+sum(valid hours)

Could you pls provide the sample data? Then we can provide proper solution for you