Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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! 🙂
Proud to be a Super User!
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! 🙂
Proud to be a Super User!
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! 🙂
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |