DAX Error: A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table
Hi, I am new to DAX. I have an assignment which requires me to convert all 3 steps tables to only one table using CALCULATETABLE function. When i tried to do for the first 2 steps, there is an error shown as below. Hereby I attach the 3 steps table for your reference: Table1: forecasting_uoa_payroll_step1 = FILTER ( uoa_payslips_history_aggregated, DATEDIFF(uoa_payslips_history_aggregated[YearMonth],TODAY(),MONTH)<variable_uoa_per_cust_window[Variable_UoA_per_Cust_Window Value]+1 ) Table 2: forecasting_uoa_payroll_step2 = SUMMARIZE ( forecasting_uoa_payroll_step1, forecasting_uoa_payroll_step1[Country], "UoA Per Customer Average", AVERAGE(forecasting_uoa_payroll_step1[UoA_per_Customer]) ) Table 3: forecasting_uoa_payroll_step3 = SELECTCOLUMNS ( customer_payroll_forecast, "Date", customer_payroll_forecast[YearMonth], "Country", customer_payroll_forecast[Country], "Customers", customer_payroll_forecast[Total Headcount] ) Thank you
