Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
Please create a calulated column like below:
C2 = IF(LEN('Table'[C1])>8,"Apple","Banana")
Please create a calulated column like below:
C2 = IF(LEN('Table'[C1])>8,"Apple","Banana")
User | Count |
---|---|
14 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
16 | |
11 | |
5 | |
4 | |
3 |