Forum Discussion

FrankieVee's avatar
FrankieVee
Frequent Visitor
6 years ago

Create a new value based on two columns in separate tables

Relatively new to Power BI, and have used this site plenty of times for assistance; figured I'd make my own post now after some prior digging. From what I've learned so far of PBI, this seems like a ...
Need Help
Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
6 years ago

FrankieVee ,

After joining Company column in both the table then Create New column in Table 1:

New = SWITCH(Tbl1[Machine Type],"WORKSTATION","Wrk_maint","SERVER","Server_Maint")