Forum Discussion

Anonymous's avatar
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.
Need Help
  • PhilipTreacy's avatar
    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

6 Replies

  • PC2790's avatar
    PC2790
    Community Champion
    5 years ago

    Hi Anonymous ,

     

    Try this:

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      PC2790   

      It error as below.

       

      suggest me about it please.

       

      • PC2790's avatar
        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.

         

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    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