DAX for calculated column based on length of the characters

[craghubi2020]

Hi,

Can you please help writing DAX for the below senerio. 

I have Column called 'C1' in T1 table. I want to create a new column called 'C2' in the same (T1) table based on length of the data in C1.

For example. column C1 is having data with character lenght between 8 to 25.

If length of C1 is > 8 characters, then it is 'Apple' in 'C2' column, if the length of C1 is lower than 8 charcters, it is Banana in 'C2' column.  

[V-lianl-msft · Accepted solution]

Please create a calulated column like below:

C2 = IF(LEN('Table'[C1])>8,"Apple","Banana")