Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
2 years ago
Solved

Team Name does not exist

Hi At present Team XYZ does not exist as its own seperate entity within the system, this team will be created in the coming months. I can however filter on the 20 employee names that will mak...
Need Help
Show and Tell
  • Slim-'s avatar
    Slim-
    2 years ago

    Hi ArchStanton 

     

    There are many ways to do it, however they can be pretty tedious if there are no data in common that differentiate these employees from other.

    For example you could create a new column in DAX with a IF(name = A || name = B || name = C || ..., Team XYZ, BLANK())

     

    Not sure if I'm clear enough,

     

    Regards,

Slim-'s avatar
Slim-
Frequent Visitor
2 years ago

Hi ArchStanton 

 

There are many ways to do it, however they can be pretty tedious if there are no data in common that differentiate these employees from other.

For example you could create a new column in DAX with a IF(name = A || name = B || name = C || ..., Team XYZ, BLANK())

 

Not sure if I'm clear enough,

 

Regards,

  • ArchStanton's avatar
    ArchStanton
    Power Participant
    2 years ago

    Thank you and apologies for the late reply, I knew about this calculated column option but tried to avoid it - don't think I have much choice.