ADDCOLUMN and CROSSJOIN issues

[davidcenna]

Hi all,

Please I would like to seek your help in solving this particular issues am having in my Module 4 EDNA Certification.
Have created my relationship and all other necessary data successfully, but when I want to create a Product Budget I kept having error. I actually don’t know what am doing wrong.

Product Budgets =
ADDCOLUMNS(
CROSSJOIN( SUMMARIZECOLUMNS( Sales[Product ID] ), DISTINCT( Dates[MonthName] ) ),
“2018 Budgets”, CALCULATE( [Total Sales], Dates[Year]= 2017 ) * 1.075 )

module 4.pbix (449.2 KB)

The error is ->
DAX comparison operations do not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.

Please your valuable solution will be kindly appreciated.

DAVID.

[BrianJ]

@davidcenna,

Your DAX looks spot on to me. The only thing I can think of is that Dates[Year] somehow got coded as type Text. Have you confirmed the type on that field?

• Brian

P.S. I was on my phone earlier and couldn’t open the PBIX, but just confirmed that is your problem - Year is a text field. Change that to whole number and you should be good to go.