Forum Discussion
PowerBI123456
Post Partisan
Post PartisanAdding Leading Zeros in Power Query
How can I add leading zeros in Power Query only if a certain criteria is met. For example, I have a column where the number of digits can range from 10-13, but all of them need to be 13 digits. So if...
PowerBI123456 , then you reference a specific column in the formula
Table.AddColumn(#"Previous step", "Leading 0s", each Number.ToText([number column], Text.Repeat("0",13)))
mahoneypat
Microsoft Employee
Microsoft EmployeeIf you need to keep them as number format, you can also use Custom Format Strings after you load the data.
Use custom format strings in Power BI Desktop - Power BI | Microsoft Docs
Regards,
Pat