cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lzombiet
New Member

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User I
Super User I

Re: DAX Syntax help - Concatenate

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


Did I answer your question? Mark my post as a solution!
Kudo's are appreciated and considered a motivation.

Proud to be a Datanaut!

View solution in original post

2 REPLIES 2
Super User I
Super User I

Re: DAX Syntax help - Concatenate

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


Did I answer your question? Mark my post as a solution!
Kudo's are appreciated and considered a motivation.

Proud to be a Datanaut!

View solution in original post

Super User I
Super User I

Re: DAX Syntax help - Concatenate

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


Did I answer your question? Mark my post as a solution!
Kudo's are appreciated and considered a motivation.

Proud to be a Datanaut!

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors