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

[UncleLewis]

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 visual
MdxScript(Model) (83,13) Calculation error in meausre 'Sales'(Selected Time Periods New]: Cannot convert value 'Year(s):' of type Text to type True/False.

PBIX is here

DAX:

Selected Time Periods New =

VAR _Div = 12

VAR _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 = 

    IF(

        _Mod = 0,

            "Year{s}: " &&

                CONCATENATEX(

                    VALUES('Calendar'[Year]),

                    FORMAT('Calendar'[Year],"0000"),

                    ", "

                ) && UNICHAR(10) &&

            "Quarter(s): " &&

                CONCATENATEX(

                    VALUES(Calendar[Quarter]),

                    Calendar[Quarter],

                    ", "

                ),

            "Year{s}: " &&

                CONCATENATEX(

                    VALUES('Calendar'[Year]),

                    FORMAT('Calendar'[Year],"0000"),

                    ", "

                ) && UNICHAR(10) &&

            "Quarter(s): " &&

                CONCATENATEX(

                    VALUES(Calendar[Quarter]),

                    Calendar[Quarter],

                    ", "

                ) && UNICHAR(10) &&

            "Month(s): " &&

                CONCATENATEX(

                    VALUES(Calendar[Month]),

                    Calendar[Month],

                    ", "

                ) 

    )

RETURN

    _Result

[PhilipTreacy · Accepted solution]

@UncleLewis 

&& is the logical comparison AND, you should be using just a single & to join strings.

Phil

[UncleLewis]

Du-oh! (Homer)

Thanks Phil!