Create a new value based on two columns in separate tables

Question

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 particularly unique request.

I have two tables, from two separate queries, and I'm looking to search one column from each for similar values, to either link or combine into a new value that I'd use to search. Its worth noting as well that one of the columns is custom.

Below is an example of the tables:

Table1, "Machine Type" column is the custom one I made based on the machine name. The goal is to be able to select "Server" or "Workstation" in a filter, and have SERVERs or WORKSTATIONs show in Table1, and Server_Maint or Wrk_maint show in Table2.

I hope I have explained this well; certianly let me know if any clarification is needed. Any help is appreciated, and thank you for the past assistance!

-Frank V.

amitchandak · Answer

FrankieVee , if these tables are joined on common key like company, you will be able to do. 
else create machine type in Table 2 also based on billed Item
You can use containsstring
https://docs.microsoft.com/en-us/dax/containsstring-function-dax
Create a common dimensions of machine type, company and analyze them together

ryan_mayu · Answer

FrankieVee&nbsp;&nbsp;Could you please show the screenshot of the expected result that you want to get?&nbsp;

tahreem24 · Answer

FrankieVee&nbsp;,
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")

&nbsp;

v-lionel-msft · Answer

Hi&nbsp;FrankieVee&nbsp;,
&nbsp;
It seems that as long as the table relationship is created.

&nbsp;
Best regards,Lionel Chen
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

v-lionel-msft · Answer

Hi&nbsp;FrankieVee&nbsp;,
&nbsp;
Has your problem been solved?
&nbsp;
Best regards,Lionel Chen
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.