SUMMARIZE function: Table with padded column?

[pbeeyeqs]

I am trying to create a table from another table and would like to pad one of the columns with leading zeros.

I am using:

SUMMARIZE(products,products[Appl_No])

and would like the column [Appl_No] to be 6 digits, padding with zeros, if necessary.

[Anonymous]

You can add a conditional column with dax like this:

AppLeading0 =
If( Len( products[Appl_No]) = 1 ; 00000 &  products[Appl_No];
If( Len( products[Appl_No]) = 2 ; 0000 &  products[Appl_No];

If( Len( products[Appl_No]) = 3 ; 000 &  products[Appl_No];
If( Len( products[Appl_No]) = 4 ; 00 &  products[Appl_No];
If( Len( products[Appl_No]) = 5 ; 0 &  products[Appl_No];
If( Len( products[Appl_No]) = 6 ;  products[Appl_No]; "Invalid length" ))))))

I know it will not be the most beautyfull solution, but it will do the job. 🙂 

[pbeeyeqs]

So, having issues: 

To create the table with 2 columns using summarize, can't figure out how to get the 2nd column. So far I have:

=SUMMARIZE(table1,table1[column])

Which is fine for the first column. How can I add to this to make the 2nd column to be the same as the first column with padding to make 6 characters in length?

COLUMN 1     COLUMN 2

14325               014325

22                     000022

415263             415263

ABC                  000ABC

[v-lili6-msft · Accepted solution]

hi, @pbeeyeqs 

You could try this formula logic to create the new table

Table = SELECTCOLUMNS(SUMMARIZE(Table1,Table1[Column1]),"Column1", RIGHT("000000"&[Column1],6))

Best Regards,

Lin