Consolidate fees from two tables with date column

[Anonymous]

I have two tables with varying columns. 

Table A has date, fees and other columns

Table B also has date, fees and other columns.

I am intrested in a third column which needs to have all the other columns from both tables with one consolidated column for fees by one date column.

Can anyone help me with the steps to achieve this?

Thanks Community!

[Ashish_Mathur]

Hi,

What do you mean by "third column"?  Did you mean "third table"?

[vicky_]

Firstly, you will need to create a date table that contains the unique dates from both tables (the easiest way is with the CALENDARAUTO() function), and then create a relationship between the new table's date column and the date columns in Tables A and B.

You can use DAX in either a calculated column or measure like:
Consolidated = SUM([Table A Fees]) + SUM([Table B Fees])

[PhilipTreacy]

Hi @Anonymous 

Not without your data I'm afraid.  Can't visualize or write any code for you with made up data.

Phil