formatting to left pad column with zeros

[TDouglassAFG]

Hi,

I have a tabular model in Visual Studio that creates a cube in analysis services for Power BI to read.  I have the same source table in two .bim's/solutions and the same calculation 

= format('Product'[Product_Code],"00000") & " - " & 'Product'[Product_Name]

However, the format is not working in one of them.  The product code is 2800.  It should be 02800 with this command.  Is there a different way I should be writing this now?  The other .bim was written over a year ago and still works ok.

[v-yiruan-msft]

Hi @TDouglassAFG ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem with yours. Thank you.

Best Regards

[v-yiruan-msft]

Hi @TDouglassAFG ,

Could you please check whether the data type of field is Text type? If yes, please set its data type as numeric type if the data is all numeric...

Best Regards