Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
Is it possible to create a new column which returns on the specified text from one column if present?
For example, below would be "KP - Section Engineers" and the new column would only show that if present
Would be blank for else
Thank you
Solved! Go to Solution.
hi @HenryJS
You could use SEARCH or FIND function to create a new calculated column as below:
https://docs.microsoft.com/en-us/dax/search-function-dax
https://docs.microsoft.com/en-us/dax/find-function-dax
Note: The SEARCH function is case insensitive. Searching for "N" will find the first occurrence of 'N' or 'n'.
For example:
FIND:
Column 1 =IF( FIND("KP - Section Engineers",[Profile Skills],1,0)=0,BLANK(), "KP - Section Engineers")
or
Column 2 = IF( FIND("KP - Section Engineers",[Profile Skills],1,0)=0,BLANK(), [Profile Skills])
SEARCH:
Column 3 = IF( SEARCH("KP - Section Engineers",[Profile Skills],1,0)=0,BLANK(), "KP - Section Engineers")
or
Column 4 = IF( SEARCH("KP - Section Engineers",[Profile Skills],1,0)=0,BLANK(), [Profile Skills])
Regards,
Lin
hi @HenryJS
You could use SEARCH or FIND function to create a new calculated column as below:
https://docs.microsoft.com/en-us/dax/search-function-dax
https://docs.microsoft.com/en-us/dax/find-function-dax
Note: The SEARCH function is case insensitive. Searching for "N" will find the first occurrence of 'N' or 'n'.
For example:
FIND:
Column 1 =IF( FIND("KP - Section Engineers",[Profile Skills],1,0)=0,BLANK(), "KP - Section Engineers")
or
Column 2 = IF( FIND("KP - Section Engineers",[Profile Skills],1,0)=0,BLANK(), [Profile Skills])
SEARCH:
Column 3 = IF( SEARCH("KP - Section Engineers",[Profile Skills],1,0)=0,BLANK(), "KP - Section Engineers")
or
Column 4 = IF( SEARCH("KP - Section Engineers",[Profile Skills],1,0)=0,BLANK(), [Profile Skills])
Regards,
Lin
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |