Hello all,
I would like to add a new column to my PowerBI dashboard.
I have an origin column with numbers. some of the numbers exist out of 4 digits and some out of 5
I would like to extract out of the numbers with 4 digits only the first digits. If the number exists out of 5 digits, i would like to extract the first 2 digits.
example
existing column --> new column
12345 --> 12
4353 --> 4
5674 --> 5
11096 --> 11
can anybody help me with a formula code that works, Thanks in advance
I would like to add a new column to my PowerBI dashboard.
I have an origin column with numbers. some of the numbers exist out of 4 digits and some out of 5
I would like to extract out of the numbers with 4 digits only the first digits. If the number exists out of 5 digits, i would like to extract the first 2 digits.
example
existing column --> new column
12345 --> 12
4353 --> 4
5674 --> 5
11096 --> 11
can anybody help me with a formula code that works, Thanks in advance