I currently have 1 calculated column from 3 separate tables that I want to bring into a new table, but PBI isn't allowing me to reference calculated columns. All three tables are share unique department names and a department ID numbers. Each table also shares this calculated column and are the columns I want to bring to a new table. How do I bring this column from each table to a new one?
Weighted Dept = SWITCH (
TRUE (),
Data[ZPPA] <= 100
&& Data[ZPPA] >= 1.996, "40",
Data[ZPPA] <= 1.996
&& Data[ZPPA] >= 1.552, "40",
Data[ZPPA] <= 1.552
&& Data[ZPPA] >= 1.108, "35.52",
Data[ZPPA] <= 1.108
&& Data[ZPPA] >= 0.664, "31.08",
Data[ZPPA] <= 0.664
&& Data[ZPPA] >= 0.22, "26.64",
Data[ZPPA] <= 0.22
&& Data[ZPPA] >= -0.224, "22.2",
Data[ZPPA] <= -0.224
&& Data[ZPPA] >= -0.668, "17.76",
Data[ZPPA] <= -0.668
&& Data[ZPPA] >= -1.112, "13.32",
Data[ZPPA] <= -1.112
&& Data[ZPPA] >= -1.556, "8.88",
Data[ZPPA] <= -1.556
&& Data[ZPPA] >= -2, "4.44",
Data[ZPPA] <= -2
&& Data[ZPPA] >= -100, "4.44",
"999999"
)
