Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
Could you please help me in achieving this either in DAX or PowerQuery.
One of my column in table has values like this.
I wanted to create another column in same table by adding "0" in the begining for the values which dose not contain "-" and other value which contains "-" should remains same as it is.
For example column 'C_SerialNumber' have values like "311211025073516" and "916429-19-11"
I wanted to add '0' in the begining if the value DOES NOT Contain '-'. So the output will be "0311211025073516" and other values remains same.
Thanks
RK
Solved! Go to Solution.
Hi! @raghukumarch
Please use this M code.
= Table.AddColumn(#"Changed Type", "Custom", each if Text.Contains([Serial Number], "-") then [Serial Number] else "0" & Text.From ( [Serial Number]
) )
Dear @raghukumarch ,
I have implemented your scenario, Here's the few steps to achieve the required output.
Go to Home - > Transform Data
Open the Query which contains the column C_SerialNumber.
Go to - > Add Column - > Custom Column
New Column Name: CheckColumn
Custom column formula: Text.Contains([C_SerialNumber],"-")
Now click on OK.
Now again click on Add Column - > Custom Column
New Column Name: NewC_SerialNumber
Custom column formula: if [CheckColumn] = false then "0" & [C_SerialNumber] else [C_SerialNumber]
Now click on OK.
Now, check on the formula bar, if the type isn't set to text then write it in a way as below screen short and click on the tick.
Here's the desire output in a new column.
Please like the reply and accept it as a solution to help the Power BI Community.
Hi! @raghukumarch
Please use this M code.
= Table.AddColumn(#"Changed Type", "Custom", each if Text.Contains([Serial Number], "-") then [Serial Number] else "0" & Text.From ( [Serial Number]
) )
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!