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,"")
Go to Solution.
View solution in original post
@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 .
Click here to learn more about the September 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
Watch Session 25 of Ted's Dev Camp.