DAX Syntax help - Concatenate

[Anonymous]

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!

[JarroVGIT · Accepted solution]

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]

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