Looking at the sample data the below calumniation is good enough:
IF [Service Date]=[Date] THEN 1 ELSE 0 END
Can you attach the sample data to understand the requirement better.
I updated the post to better explain my request.
I Need to know if "Product" changed on "Service Date" by "Account".
You're really close with your current calc. You just need to convert the date values to strings with the str() function to make that error go away.
Update your calc to this:
IF str([Service Date]) = str([Date]) AND LOOKUP(ATTR([Product]),-1) != ATTR([Product])
Hahaha no shame involved! Tableau has some weird default behavior that you just need to code around.
In this case it's saying that the Product metrics you're using in your Lookup calc are aggregated, while the date fields aren't. Just need to add the attr() wrapper around the dates and it should fix it:
IF str(attr(Service Date])) = str(attr([Date])) AND LOOKUP(ATTR([Product]),-1) != ATTR([Product])
YOU ARE THE MAN!!!!!!! THANK YOU!!!!!!! THANK YOU!!!!!!! THANK YOU!!!!!!!
You're very welcome! If you don't mind, can you click the "Yes" next to "This Helped Me" on my response? I'm trying to level up my forum status Thanks!