Create calculated columns by summing values in another table

Hi Ahmedx ,

Apologise for the delay in response!

Brilliant, many thanks for wonderful solution.

Will get back on this after testing them😊

Thanks

Hi Ahmedx ,

Many thanks for your patience

Today I had a chance to test this and found the below:

The solution is perfect and it works great. But I need a slight change with a way this measure sums the Target value.

I have this below dataset after testing:

Target table:

Missing Dates table:

Month Lookup

This measure currently sums all the target value for their corresponding DBName_Point_id.But this measure should also sum target value corresponding to their target table Month(Value Type).

The month in Date column should match corresponding month(Value Type) in Target table and get the value.

I am confused how to modify this measure to include the filter condition target table Month(Value Type)

as they don't have month name directly specified(ex:Value_01 for January,Value_02 for February etc.). I had created the Month lookup table and tried but didn't help.

The expected output:

This above 659.599 is the corresponding target value of INSE-792 for month of December(Value_Type 12).

Can you please guide me on this ?

PFA sample file in below link:

Calculated column referencing other tables_total.pbix

Please let me know if you need further info.

Thanks in advance

Ahmedx grantsamborn Greg_Deckler