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, M11LEX, M10LEX - the DAX below isnt working. any ideas ?
@amitchandak @goncalogeraldes @tamerj1
Solved! Go to Solution.
Hi @spandy34
Hope you're doing fine.
Please try
Test =
IF (
CONTAINSSTRING ( INS_Premium[PolicyCode], "LEX" ),
'INS_Premium'[NetPremium]
)
Hi @spandy34
Hope you're doing fine.
Please try
Test =
IF (
CONTAINSSTRING ( INS_Premium[PolicyCode], "LEX" ),
'INS_Premium'[NetPremium]
)
User | Count |
---|---|
126 | |
63 | |
56 | |
47 | |
41 |
User | Count |
---|---|
118 | |
67 | |
63 | |
63 | |
44 |