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 Suppre...
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! 🙂

JarroVGIT's avatar
JarroVGIT
Icon for Resident Rockstar rankResident 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
    Icon for Resident Rockstar rankResident 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! 🙂