Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
226 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Using and learning Power BI I'm willing to Find text within a string using a Measure or variable.
Here is my attempt that works fine if I use text on the DAX Formula.
Column 1 = CONTAINSSTRING(Groupofcities[Cities],"KC")
Cities | Column 1 |
---|---|
DAL, HOU, DET, KC, CHI | TRUE |
DAL, HOU, CHI | FALSE |
This is what I'm willing to do but does not work
Column 1 = CONTAINSSTRING(Groupofcities[Cities], [Measure City])
Extra point if you help me on using multiple values, if KC and CHI are selected how can still say true to the first row and false to the second?
Thanks so much.