Consolidate two tables by filling in values from 2nd table into 1st table that = 0

[Alicia_Anderson]

I have 2 tables: 1st provides the saved amount, 2nd provides the current calculated amount and is a calculated table.    

I want to create a new table that takes the saved amount from the 1st table and then uses the value from the 2nd table to fill in the values that are 0 in the 1st table.  

The result should look like this:

[Anonymous]

@Alicia_Anderson based on your info,

Use below dax to get the desired output as a Calcualted table.

Pan-Saved = 

SELECTCOLUMNS(SAVED,
"Team",SAVED[Team],
"C1",SAVED[C1],
"C2",IF(SAVED[C2] = BLANK() ,LOOKUPVALUE(Plan[Plan],Plan[Team],SAVED[Team]),SAVED[C2]),

"C3",IF(SAVED[C3] = BLANK() ,LOOKUPVALUE(Plan[Plan],Plan[Team],SAVED[Team]),SAVED[C3]))

Let me know if that works for you.

Thanks,

Mohan V.

[Alicia_Anderson · Accepted solution]

I was able to get this to work by pivoting the table.   Thanks for the info.  

[Alicia_Anderson]

Thanks for the quick response.   I am getting the following error: 

Current Plan-Saved is in this format: 

[Anonymous]

@Alicia_Anderson check the datatype's of the columns that you are referring to.