I watched Sam’s Calculate Previous Week’s Sales video and copied the code for a similar calculation in my file. When I go to bring the [PriorSales] measure into my visual, I receive an error that the data couldn’t be loaded due to improper combination of formats (text with number). [See screenshot] Would this be because the SELECTEDVALUE function returns a text value for Week and Year, and then the operation is trying to subtract -1 from the text value and that’s returning the error? I’ve checked the formats on all my measures and they are Whole number. I feel like I’m the only one experiencing this error when in the video and elsewhere on this forum the exact same coding is used without throwing the error - disconcerting, but I will plod on. . . !
Screenshot 5-1-20.pdf (169.0 KB)