Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

IF Statement with Text.Length and Concat

Hi Experts,   Below is my table in Power Query   I am adding a Custom column using the if statement in Text.length, below is the power query    However, after adding the custom colu...
Need Help
Show and Tell
  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    Hi Anonymous ,

    Adjust to the below:

    if Text.Length([FLT_CLS_T])  =1 then "000"&([FLT_CLS_T]) else if Text.Length([FLT_CLS_T]) =2 then   
"00"&([FLT_CLS_T]) else if Text.Length([FLT_CLS_T]) =3 then   "0"&([FLT_CLS_T]) else [FLT_CLS_T]

     

    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien

v-luwang-msft's avatar
v-luwang-msft
Community Support
4 years ago

Hi Anonymous ,

Adjust to the below:

if Text.Length([FLT_CLS_T])  =1 then "000"&([FLT_CLS_T]) else if Text.Length([FLT_CLS_T]) =2 then   
"00"&([FLT_CLS_T]) else if Text.Length([FLT_CLS_T]) =3 then   "0"&([FLT_CLS_T]) else [FLT_CLS_T]

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien