Forum Discussion
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 ...
amitchandak
Super User
Super UserFrankieVee , 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