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 =
CROSSJOIN( SUMMARIZECOLUMNS( Sales[Product ID] ), DISTINCT( Dates[MonthName] ) ),
“2018 Budgets”, CALCULATE( [Total Sales], Dates[Year]= 2017 ) * 1.075 )
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.