week
1 Topic
Error: Comparison operations don't support comparing values type Text with Values of Type Number
Hi, I'm new to DAX and need some help, I'm creating a measure in a tabular cube in SSAS. I need to retreive the LastYearLastWeek data from x column: LastYearLastWeek:= CALCULATE([x], FILTER(ALL(Time), Time[WeekNumber] = SELECTEDVALUE(Time[WeekNumber]) -1 && Time[Year] = SELECTEDVALUE(Time[Year])-1)) But I get this error in the syntax: comparison operations don't support comparing values type Text with Values of Type Number. Considering using VALUE or FORMAT functions to convert one of the values. Fields used: WeekNumber and Year from Time table are whole numbers. It doesn't really make sense to me, any tips on how to fix it? Also maybe there is a better way to get LastWeekLastYear, do you know of any? ThanksSolved1.4KViews0likes2Comments