Expression.Error: We cannot apply operator & to types Number and Text

Tanmaub8055 

Here is a similar blog or post to follow Solved: Expression.Error: We cannot apply operator - to ty... - Microsoft Power BI Community

HINT

Indeed The list.sum caused the error when i pivoted the column. I realize the that the column i pivoted has both numberical and text values. I changed from sum to "dont aggregate" and now the model works fine. Not concerned with not summing my like-like values as the raw data are summations already from previous models.

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users