spandy34Responsive Resident4 years agoSolvedIF Lookup Column Hi I want to create a column where in the column named Test it returns the Net Premium Value if the Policy Code includes the letters LEX. The format of the data in the Policy Code could be M05LEX, ...Show Moretamerj14 years agoHi spandy34 Hope you're doing fine.Please tryTest = IF ( CONTAINSSTRING ( INS_Premium[PolicyCode], "LEX" ), 'INS_Premium'[NetPremium] )
tamerj14 years agoHi spandy34 Hope you're doing fine.Please tryTest = IF ( CONTAINSSTRING ( INS_Premium[PolicyCode], "LEX" ), 'INS_Premium'[NetPremium] )
tamerj14 years agoHi spandy34 Hope you're doing fine.Please tryTest = IF ( CONTAINSSTRING ( INS_Premium[PolicyCode], "LEX" ), 'INS_Premium'[NetPremium] )
Related contentLookup helplookup value in another columnLookup to unrelated table in calculated columnLookup for multiple columnsLookup between two dates
