March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I have a column "Item" that I would like to find all values start with "SK" or "78", then insert a text "Do Not Use" to the custom column, otherwise, carry the values from column Item over as is. Can someone help with this please?
Solved! Go to Solution.
I would create a column
_new_column = IF(LEFT([column],2) IN {"SK","78"}, "Do Not Use",[column])
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
I would create a column
_new_column = IF(LEFT([column],2) IN {"SK","78"}, "Do Not Use",[column])
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
@Ajinkya369 attaching image of data and the result I would like to achieve. Need help with Dax formula or custom column formula please. Thank you.
Using the CONTAINSSTRING function:
Proud to be a Super User!
Paul on Linkedin.
You can create a custom column in Power Query to meet the output. The interface will allow you to choose between "contains" (to specify the string values) and the output can be custom or a column value
As an alternative, you can create a custom column using DAX in your table using the function CONTAINSTRING as the variable
Proud to be a Super User!
Paul on Linkedin.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
114 | |
76 | |
57 | |
52 | |
44 |
User | Count |
---|---|
167 | |
117 | |
63 | |
57 | |
50 |