Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a column in Power Bi with Employee Name which has mix of club employee and fcs employee.
I want to create 2 new columns : 1. Club Employee 2. Fcs Employee
The name that starts with FCS is all fcs employee and the reamaining are club employee.
Solved! Go to Solution.
Hi @Timbuktu7
Please try this, create a new column
IsFcs = IF(CONTAINSSTRING('Table'[Employee Name],"Fcs"),1,0)
Since there is no relationship between Club Employee and Fcs Employee, you need to put them into separate tables
table1 = SELECTCOLUMNS(FILTER('Table','Table'[IsFcs]=1),"Fcs",[Employee Name])
table2 = SELECTCOLUMNS(FILTER('Table','Table'[IsFcs]=0),"Club Employee",[Employee Name])
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi @Timbuktu7
Please try this, create a new column
IsFcs = IF(CONTAINSSTRING('Table'[Employee Name],"Fcs"),1,0)
Since there is no relationship between Club Employee and Fcs Employee, you need to put them into separate tables
table1 = SELECTCOLUMNS(FILTER('Table','Table'[IsFcs]=1),"Fcs",[Employee Name])
table2 = SELECTCOLUMNS(FILTER('Table','Table'[IsFcs]=0),"Club Employee",[Employee Name])
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
48 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
58 | |
29 | |
21 | |
16 |