Hi, I have two tables. One is pulling actual sales numbers from our SAP and another is a excel sheet with sales projection numbers here are two simple mock ups: CustomerMonthProjA9/1/20196000A10/1/20198000A11/1/20195000A12/1/201910000B9/1/20195000B10/1/20197000B11/1/20194000B12/1/20199000 CustomerMonthActualA9/1/20195678A10/1/20196789A11/1/20197891A12/1/20190B9/1/20194321B10/1/20191234B11/1/20195647B12/1/20190 I want to add a calculated column to the first table that will take the actual numbers by customer and date from the second table and place them in the projection table for previous months. This would be done in excel by having a formula for each cell do:=IF(MONTH(MONTH)<MONTH(TODAY()),SUMIFS(Actual,Customer,Customer,Date,Date),Proj) CustomerMonthProjFinalA9/1/201960005678A10/1/201980006789A11/1/201950007891A12/1/20191000010000B9/1/201950004321B10/1/201970001234B11/1/201940005647B12/1/201990009000 In BI i'm trying to write a calculated column like Final = IF(MONTH(Month)<MONTH(TODAY()),CALCULATE(SUM(ACTUAL),MONTH(Month)=MONTH(Month)),Proj) but it throws back a "The expression contains multiple columns, but only a single column can be used in a True/False expression that is used as a table filter expression."

Hi JasonTX ,First create a key column in both table by concatinating Month and Customer then relate the tables using key column, after that you can get Proj from table1 using RELATED function.Key = Table1[Month]&Table1[Customer]Proj = RELATED(Table1[Proj])Relation:Output:Best Regards,Mail2inba4If this post helps, then please consider Accept it as the solution to help the other members find