Forum Discussion

JMWDBA's avatar
JMWDBA
Advocate II
9 years ago
Solved

Merging 3 calculated columns

So I am not certain if I went about this the right way but below are the formulas that drive 3 calculated columns based on the specified criteria.  Now what I need is to collapse the 3 columns into 1 column called "Term Status".  Can I do that and if so, how?

 

Term Veteran = IF('WW Registrations'[Term Military or Civilian]= "Civilian" && ('WW Registrations'[Term - Prior Branch of Service]="Yes"),"Veteran")

 

Term Civilian = IF('WW Registrations'[Term Military or Civilian]= "Civilian" && ('WW Registrations'[Term - Prior Branch of Service]="No" || 'WW Registrations'[Term - Prior Branch of Service]=""),"Civilian") 

 

Term Military = IF('WW Registrations'[Term Military or Civilian]= "Miltiary" && ('WW Registrations'[Term - Prior Branch of Service]="Yes" || 'WW Registrations'[Term - Prior Branch of Service]=""),"Military")

 

Each individual gives a column with the correct information but I need [Term Veteran] + [Term Civilian] + [Term Military] with this information in one column called [Term Status]

Need Help
  • JMWDBA's avatar
    JMWDBA
    9 years ago

    The solution is actually just the following:

     

    Term Status = ('WW Registrations'[Term Civilian] & ('WW Registrations'[Term Veteran] & ('WW Registrations'[Term Military])))

3 Replies

  • JMWDBA's avatar
    JMWDBA
    Advocate II
    9 years ago

    The solution is actually just the following:

     

    Term Status = ('WW Registrations'[Term Civilian] & ('WW Registrations'[Term Veteran] & ('WW Registrations'[Term Military])))

  • Hasan's avatar
    Hasan
    Resolver I
    9 years ago

    Have you try the

    CONCATENATE([Term Veteran] + [Term Civilian] + [Term Military])