Forum Discussion
Solved
Leading Zero Issue
Hello everyone I am having trouble with the Zip codes when it has 0 as the leading. Example : I have data like this in excel NJ 07306 TN 38120 When i imported into Power BI, it is ...
Quick solution is to create a new custom column in DAX with a formula:
FullZip = FORMAT([Zip], "00000")
Where [Zip] is your zip code field name.
Quick solution is to create a new custom column in DAX with a formula:
FullZip = FORMAT([Zip], "00000")
Where [Zip] is your zip code field name.
Thank you so much Ross