Error Cannot Convert Value of Type Text to Type True/False

Question

Hi all,Using up-to-date PBID.This error confuses me since it refers to Year column which shows as whole number in power query.What am I missing here?Error:Error fetching data for this visualMdxScript(Model) (83,13) Calculation error in meausre 'Sales'(Selected Time Periods New]: Cannot convert value 'Year(s):' of type Text to type True/False.&nbsp;PBIX is here&nbsp;DAX:Selected Time Periods New =VAR _Div = 12VAR _Rows_Months = COUNTROWS(VALUES(Calendar[Month]))Var _Mod = MOD(_Rows_Months,_Div)VAR _Rows_Quarters = COUNTROWS(VALUES(Calendar[Quarter]))VAR _Rows_Years = COUNTROWS(VALUES('Calendar'[Year]))VAR _Result = &nbsp; &nbsp; IF(&nbsp; &nbsp; &nbsp; &nbsp; _Mod = 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Year{s}: " &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CONCATENATEX(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VALUES('Calendar'[Year]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FORMAT('Calendar'[Year],"0000"),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ", "&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ) &amp;&amp; UNICHAR(10) &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Quarter(s): " &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CONCATENATEX(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VALUES(Calendar[Quarter]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Calendar[Quarter],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ", "&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Year{s}: " &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CONCATENATEX(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VALUES('Calendar'[Year]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FORMAT('Calendar'[Year],"0000"),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ", "&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ) &amp;&amp; UNICHAR(10) &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Quarter(s): " &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CONCATENATEX(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VALUES(Calendar[Quarter]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Calendar[Quarter],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ", "&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ) &amp;&amp; UNICHAR(10) &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Month(s): " &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CONCATENATEX(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VALUES(Calendar[Month]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Calendar[Month],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ", "&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ) &nbsp; &nbsp; )RETURN&nbsp; &nbsp; _Result

philiptreacy · Accepted Answer

UncleLewis&nbsp;
&nbsp;
&amp;&amp; is the logical comparison AND, you should be using just a single &amp; to join strings.
&nbsp;
Phil

Forum Discussion

Error Cannot Convert Value of Type Text to Type True/False

2 Replies

Related content

Convert True False and Count - DAX Help

True/False, if statement

DAX Involving TRUE/FALSE Column

Cannot Convert value of type text to type true false

True/False Measure