How do i complete a formula similar to the followiing that im using in excel so i complete this in Power BI please. =IF(ISNUMBER(SEARCH("Photo-Display",H2)),$I$1,"")
Many thanks
Solved! Go to Solution.
@Blondyvl can you share a sample pbix or a sample data and the desired result in PBI?
I can't share the file, however i have got this working for the first few words in the string seperated by commas, im now stuck on the words with the dash in the middle.
I have a collumn that could contain any of these in a string seperated by a comma.
School Visit, PE Fixture, Medical, Blood transfusion, Biometric Consent, Photo-Display, Photo-Social Media, Photo-Press, Photo-Class Photo, Photo-Productions.
Im trying to seperate this string to make collums that only show me the people that have consented for the options they have ticked .
Eg
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
119 | |
75 | |
66 | |
51 | |
49 |
User | Count |
---|---|
183 | |
101 | |
80 | |
79 | |
77 |