Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there
Please can someone help me with my statement. Im using a like but im getting an error on my like
Below is my statement
if [strSerialNumber] like '%ZF%' then [Line Total Incl]*[ZF Split]/100 else [Line Total Incl] * [All Split]\100
Thanks
Muhie
Solved! Go to Solution.
Hi @muhie,
Assume you want to use DAX, you can create a calculated column like below:
Column 2 = IF(SEARCH("ZF",Table1[strSerialNumber] ,1,0),Table1[Line Total Incl]*Table1[ZF Split]/100,Table1[Line Total Incl]*Table1[All Split]/100)
Best Regards,
Qiuyun Yu
Hi @muhie,
Assume you want to use DAX, you can create a calculated column like below:
Column 2 = IF(SEARCH("ZF",Table1[strSerialNumber] ,1,0),Table1[Line Total Incl]*Table1[ZF Split]/100,Table1[Line Total Incl]*Table1[All Split]/100)
Best Regards,
Qiuyun Yu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |