Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi I have values in a table that are char 3 or 2, how can I change in char 4?
example : 170 I want to turn it into 0170
Hi @Marcox28,
You can also try the function FORMAT.
Column = FORMAT([Column1], "0000")
Best Regards,
Dale
Hi,
As per your question your values are either of 2 or 3 characters. You can use concatenate function. create a column where you should check length of your character. If it is less than 3 then concatenate it with "00" and if length of character =3 then concatenate it with "0".
check the below expression if this works as per your requirements.
column = if(LEN(your field)<3,CONCATENATE("00",your field),if(LEN(your field)=3,CONCATENATE("0",your field))). Check teh screenshot below.
Thanks,
Atish
User | Count |
---|---|
89 | |
75 | |
69 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
74 | |
60 | |
59 |