User Profile
JimmyBos
Helper II
Joined 1 year ago
User Widgets
Contributions
Re: Using Multiple 'Substitute' in one formula
Hello Cookistador , This fixed both issues, thanks! Just noticed there small issue left. First i would like to show you what i am filtering with the formula you gave me. Everything related to a project we name something like PR2500042.01 or PR2500042.01 or I2500042 or PRVH2500042. All belong to project 2500042. The formula will tell me which project something is related to. See screenshot below. If for example PR2500042.01 was written with small letters (pr2500042.01) i would still like to get the same outcome: 2500042. Would your formula give me the same outcome?994Views0likes2CommentsRe: Using Multiple 'Substitute' in one formula
Hello Cookistador , Thank you for showing me this formula. There are 2 small adjustments needed. The first issue is, when i add this formula to my visual, many extra rows pop up. There should be a line added like: 'IF( NOT(ISBLANK(???)),' I tried to get it working, but i do not know what to place on the '???'. The second is this formula has a result of 6 characters. There should be 7. (changing the '7' in your formula to '8' did not change the output.1KViews0likes4CommentsUsing Multiple 'Substitute' in one formula
Hello All, once more, and it looks like the last formula i would like to 'perfect' contains multiple 'Substitute'. Any idea how to change the formula into a bit easier to read? Formula as it is: Project clean = LEFT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SELECTEDVALUE(POStuklijst[ParentProject])," ",""),"A",""),"B",""),"C",""),"D",""),"E",""),"F",""),"G",""),"H",""),"I",""),"J",""),"K",""),"L",""),"M",""),"N",""),"O",""),"P",""),"Q",""),"R",""),"S",""),"T",""),"U",""),"V",""),"W",""),"X",""),"Y",""),"Z",""),7)Solved1.1KViews0likes6CommentsRe: Measure 'Contains' multiple.
Hello v-nmadadi-msft , Thanks once more for you assistance. I have tried the formula you used, for this give the same error. Any idea how that is possible? The formula: BoutenMoerenTest = VAR SearchTerms = ADDCOLUMNS( DATATABLE("Term", STRING, { {"Tapbout"}, {"Moer, zeskant"}, {"Moer, zelfborgend"}, {"Carosseriering"}, {"Stafstaal"}, {"Sluitring"}, {"Onderlegring"}, {"Draadstang"}, {"Lasstiftbout"}, {"Assemblage"}, {"Dummy"}, {"Slotbout"}, {"Stelschroef"} } ), "Match", IF(CONTAINSSTRING(SELECTEDVALUE(POStuklijst[description]), [Term]), 1, 0) ) VAR Description = SELECTEDVALUE(POStuklijst[description]) RETURN IF( NOT ISBLANK(Description) && SUMX(SearchTerms, [Match]) > 0, TRUE(), FALSE() ) The error: The syntax for Description is incorrect. (DAX(VAR SearchTerms = ADDCOLLUMNS(DATATABLE("term", STRING, {{"Tapbout"}.......1.8KViews0likes1CommentRe: Measure 'Contains' multiple.
Hello v-nmadadi-msft , Thanks for helping me out here. Most likely i misunderstand the problem, but when i tried to change the formula pankajnamekar25 send, it still returns the same error. The formula i tried: Bouten&Moeren test = VAR SearchTerms = {"Tapbout", "Moer, zeskant", "Moer, zelfborgend", "Carosseriering", "Stafstaal", "Sluitring", "Onderlegring", "Draadstang", "Lasstiftbout", "Assemblage", "Dummy", "Slotbout", "Stelschroef"} VAR Description = SELECTEDVALUE(POStuklijst[description]) RETURN IF( NOT ISBLANK(Description) && SUMX(SearchTerms, IF(CONTAINSSTRING(Description, SearchTerms), 1, 0)) > 0, TRUE(), FALSE() )1.8KViews0likes3CommentsRe: Measure 'Contains' multiple.
Hello pankajnamekar25 , Thanks you for the reply. This is what i am looking for but there is an error left. The syntaxis for Description is incorrect. (DAX(VAR SearchTerms={"Tapbout"............} VAR Description = SELECTEDVALUE(POStuklijst[Description])RETURNIF(NOT ISBLANK(Description)&&SUMX(SearchTerms, CONTAINSSTRING(Description, [Value]... Any idea how to fix this one?1.9KViews1like7CommentsMeasure 'Contains' multiple.
Hello all, Have another question regarding one of my formula's. Am sure the solution is easy! How to write the following Measure easier. Bouten&Moeren = CONTAINSSTRING(SELECTEDVALUE(POStuklijst[description]),"Tapbout")|| CONTAINSSTRING(SELECTEDVALUE(POStuklijst[description]),"Moer, zeskant")|| CONTAINSSTRING(SELECTEDVALUE(POStuklijst[description]),"Moer, zelfborgend")|| CONTAINSSTRING(SELECTEDVALUE(POStuklijst[description]),"Carosseriering")|| CONTAINSSTRING(SELECTEDVALUE(POStuklijst[description]),"Stafstaal")|| CONTAINSSTRING(SELECTEDVALUE(POStuklijst[description]),"Sluitring")|| CONTAINSSTRING(SELECTEDVALUE(POStuklijst[description]),"Onderlegring")|| CONTAINSSTRING(SELECTEDVALUE(POStuklijst[description]),"Draadstang")|| CONTAINSSTRING(SELECTEDVALUE(POStuklijst[description]),"Lasstiftbout")|| CONTAINSSTRING(SELECTEDVALUE(POStuklijst[description]),"Assemblage")|| CONTAINSSTRING(SELECTEDVALUE(POStuklijst[description]),"Dummy")|| CONTAINSSTRING(SELECTEDVALUE(POStuklijst[description]),"Slotbout")|| CONTAINSSTRING(SELECTEDVALUE(POStuklijst[description]),"Stelschroef")Solved1.9KViews1like11Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.