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...
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])))

Hasan's avatar
Hasan
Resolver I
9 years ago

Have you try the

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

 

JMWDBA's avatar
JMWDBA
Advocate II
9 years ago

Yes, it does not work.