Adding calculated columns from 3 different tables to a new table

Anonymous — Tue, 22 Sep 2020 19:22:48 GMT

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"

)

Re: Adding calculated columns from 3 different tables to a new table

amitchandak — Wed, 23 Sep 2020 02:35:00 GMT

Anonymous , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

topic Re: Adding calculated columns from 3 different tables to a new table in DAX Commands and Tips

Adding calculated columns from 3 different tables to a new table

Re: Adding calculated columns from 3 different tables to a new table