The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All, I had requirement that states if product name like 'Jacket %' Or Product name like 'Shirt%' then expected value =Product Cost/1000 Other wise keep value as it is for rest of product names. How to do this in Query Edictor by adding new calculated column. Please help. So below Product Names especially for Jacket, Shirt appended with some other text so I need to choose Like operation only for example : Product Name LIKE 'Jacket%' etc..
Solved! Go to Solution.
Hi @srisiva55
1. Add a Calculated Column and use the formula mentioned below and see if it works. Change the column values as per your table
If the suggestion helps, give a kudo and mark my reply as a solution 🙂
Hi @srisiva55
1. Add a Calculated Column and use the formula mentioned below and see if it works. Change the column values as per your table
If the suggestion helps, give a kudo and mark my reply as a solution 🙂