Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
craghubi2020
Frequent Visitor

DAX for calculated column based on length of the characters

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.  

1 ACCEPTED SOLUTION
V-lianl-msft
Community Support
Community Support

Please create a calulated column like below:

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

V-lianl-msft_0-1619661474210.png

 

View solution in original post

1 REPLY 1
V-lianl-msft
Community Support
Community Support

Please create a calulated column like below:

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

V-lianl-msft_0-1619661474210.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.