Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX Syntax help - Concatenate

I inherited an SSAS model that we visualize in PowerBI.  The report has stopped working and when I drill in, I get the following error in the model: Severity Code Description Project File Line Suppression State
Warning Calculated column 'dTBMTaxonomy-FY2017'[ConcatforATUM] : The syntax for '(' is incorrect. (DAX(
CONCATENATE([Vendor],concatenate("^",concatenate([Product],'dTBMTaxonomy-FY2017'("^",'dTBMTaxonomy-FY2017'[SubProductCategory]))))
)). 

 

The formula is defined as: =CONCATENATE([Vendor],concatenate("^",concatenate([Product],'dTBMTaxonomy-FY2017'("^",'dTBMTaxonomy-FY2017'[SubProductCategory]))))

 

I have verified that the number of open parens is equal to closed, but that is the limit of my DAX knowledge.  Can anyone help?  Thank you!

Need Help
  • JarroVGIT's avatar
    JarroVGIT
    6 years ago
    CONCATENATE([Vendor],
   concatenate("^",
      concatenate([Product],
         'dTBMTaxonomy-FY2017'("^", <---------
         'dTBMTaxonomy-FY2017'[SubProductCategory]))))


    Where the arrow is, doesn't make any sense. The word CONCATENATE was dropped, and 'dTBMTaxonomy-FY2017' does not belong there. Don't know ofcourse what it should be but the '('  in the middle is throwing the error 🙂

     

    Kind regards

    Djerro123

    -------------------------------

    If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

    Keep those thumbs up coming! 🙂

2 Replies

  • JarroVGIT's avatar
    JarroVGIT
    Resident Rockstar
    6 years ago
    CONCATENATE([Vendor],
   concatenate("^",
      concatenate([Product],
         'dTBMTaxonomy-FY2017'("^", <---------
         'dTBMTaxonomy-FY2017'[SubProductCategory]))))


    Where the arrow is, doesn't make any sense. The word CONCATENATE was dropped, and 'dTBMTaxonomy-FY2017' does not belong there. Don't know ofcourse what it should be but the '('  in the middle is throwing the error 🙂

     

    Kind regards

    Djerro123

    -------------------------------

    If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

    Keep those thumbs up coming! 🙂

    • JarroVGIT's avatar
      JarroVGIT
      Resident Rockstar
      6 years ago

      Also, it is often more readable if you use '&' like this:

      Column = 'Table'[TextColum] & "^" & 'Table'[NumberColumn]

      That is much more readable than nesting multiple CONCATENATE statements..

       

      Kind regards

      Djerro123

      -------------------------------

      If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

      Keep those thumbs up coming! 🙂