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

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.

       

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