Forum Discussion

Krish_76's avatar
Krish_76
Frequent Visitor
9 years ago
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 ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    9 years ago

    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.

ACT's avatar
ACT
Frequent Visitor
8 years ago

I am too...I tried to write it within the Advanced Query Editor rather than creating a new column as well...tried to edit format changes, etc. Can't seem to get it to work. =(

Anonymous's avatar
Anonymous
Not applicable
8 years ago

This is because its a DAX created column, not a Power Query formula.

 

EDIT:  You beat me to it :P