How to add a calculated measure from one table to a column value in another table

[Anonymous]

I have a calculated measure which I have created for a table which does the following:

Net Daily Inflows = 'Maitland Daily Flows'[Latest Daily Inflow] - 'Maitland Daily Flows'[Latest Daily Outflow]

This measure is made up of two measures:

Latest Daily Inflow = CALCULATE(SUM('Maitland Daily Flows'[Purchase]), LASTDATE('Maitland Daily Flows'[Trade Date]))

Latest Daily Outflow = CALCULATE(SUM('Maitland Daily Flows'[Redemption]), LASTDATE('Maitland Daily Flows'[Trade Date]))

I have now imported another table into Power BI which I have called Daily NAV and this table contains two colums, a date field and value field which associates a value to each date. This value field is the Daily NAV

I want to create a new column by either creating a calculated column or measure, where for any date I can see the sum of the Daily NAV and the Net Daily Inflow (measure for my first table).

I am not sure where to start with this, whether I should create a calculated measure or column and if I need to join both my tables first?

Thank you all,

K

[Anonymous]

Hi @Anonymous ,

According to your statement, I think your issue should be caused by your data model.

Please share a sample file with us and show us a screenshot with the result you want, this will make it easier for us to find the solution.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[CoreyP]

The tables definitely have to be related to eachother. Based on your description, the best course would be to create a date dimension table and establish a relationship to each of the tables. This will connect the tables based on date, and you'll be able to reference the fields and measures from both tables.