Forum Discussion
Helper IIText comparison (LIKE operator)
you could use the FIND ( ) function to test if the text string is found
FIND (find_text, within_text, [start_num], [NotFoundValue])
Having said that, I think there is a very good chance that your data design is not optimal for Power Pivot. Can you share your table data structure here? I suspect there is a better way to pre-format your data before loading to be more efficient and effective.
Community Championyou could use the FIND ( ) function to test if the text string is found
FIND (find_text, within_text, [start_num], [NotFoundValue])
Having said that, I think there is a very good chance that your data design is not optimal for Power Pivot. Can you share your table data structure here? I suspect there is a better way to pre-format your data before loading to be more efficient and effective.
Helper IIMatt,
Thank you for your response and suggestion regarding the issue. I'm currently looking into alternate ways in which to store the data; unfortunately this has been designed by external developers and I don't have much say in the matter.
Failing that, will look at perhaps some functoins in which I can confirm whether the text value exists within the text string.
- MattAllington
Power Query is explicit designed to help you clean and shape your data during load. You should check it out - it's easy to learn.
http://exceleratorbi.com.au/what-is-power-query/
the FIND function I mentioned will work otherwise