Forum Discussion

samroth's avatar
samroth
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Create column based off substrings from different table

I have two tables. The first is my main table with a bunch of information on items. One of the columns is an "Area Path". The following is a made-up example with similar information to what can be...
Need Help
samroth's avatar
samroth
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Thanks Greg, where I am supposed to put this code to run in the pbix?

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi , samroth 

As shown in the attached file provided by Greg_Deckler ,you just need to create a calculated column.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.