Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |