Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

Measure error

Measure error Measure = CONCATENATE("Update") & CONCATENATE( 'Before'[Team]) Sheet Before Name column Team Guide me please.

PhilipTreacy
5 years ago
Hi Anonymous

Try this

Measure = CONCATENATE("Update", MAX('Before'[Team]))

If that doesn't work please supply some sample data.

regards

Phil

Community Champion

5 years ago

Hi Anonymous ,

Try this:

Measure = CONCATENATE("Update", 'Before'[Team])

Anonymous

Not applicable

5 years ago

It error as below.

suggest me about it please.

PC2790
Community Champion
5 years ago
As you are creating a measure of the column containing multiple values, you are getting this error as it requires an aggregation on the column level.

Try creating a calculated column rather than a measure. This will fix your issue.
- Anonymous
  Not applicable
  5 years ago
  PC2790 yes, in column department have more value.
  Now, if i use card for show department, it show correct.
  But I want to add text before department
  
  Suggest me please.
  - PC2790
    Community Champion
    5 years ago
    Can you be more elaborative about your issue?
    It would help is you can explain using your data examples and screenshots.
    
    Also, ss your initial issue of concatenating the two values- "Update" & Before [Team] column sorted?