Hello,
Please help with the approach I need to follow in my case.
I have a table1 with userid, locationid, date, and
table 2 with locationid, loc, username, prodname.
In the begining of the year they changed prodname for one product from "oldpn" to "newpn" but both have the same locationid(1234). so in the existing report when "newpn" is selected in the option, the measures calculates count(userid) which include "oldpn" numbers as well.
To avoid this I thought replace the userid in table1 to null or something when locationid = 1234 and date <"01/01/2023", but that didn't work. Also I don't want to change the data if possible.
Can someone please provide a better approach for my problem. I am not sure if I clear enough in explaining my situation as well. But please let me know will try to explain in better way, have been struggling with this since 3 days already. Thank you for any help you can provide. Thanks...
