Trying to use a string in a column to come up with a name
Hello, Sorry if I am not the best at explaining, I am fairly new to Power BI, but I will try to do my best. Basically I have a columnn [apppreffer] where about a third of the rows have some sort of variation of med001, med002...and so on. They located in the middle of a string such as DonnaApp_med001_CDL. Each of the med codes have a certain name that corresponds with them. I tried doing something with the containtstring fucntion and then the search function but I couldn't get the formatting correct. Any help is greatly appreciated.
Maybe? So i go and add a new column from examples, and in that I put all the different med cods in that column? theres a lot more columns in the table than I showed. There is about 7 million rows of data so would that then automatically go through all of them and trnasform the codes into the company names?
If you type in several of the rows that have _med007_ then it will work out what you want to do and it will extract the med codes into one column automatically. You will then be able to link the new med code column to the relevant company name. If I've followed you correctly. Columns from Examples is really powerful.
Did I answer your question? Mark my post as a solution!
Is column from examples available on Power BI Desktop? or just the regular version? Would one option be to create a column that pulls out any med codes, then make a table with all the med codes and corresponding names and then connect the two? Would that be easier? Sorry if I don't understand everything.