In my PowerCLI & vSphere statistics – Part 5 – Rollup Types post, there is a script that looks at average CPU and memory consumption for VMs.
It data from the last 2 minutes, you could adapt that to another time range (and remove the Realtime switch).
But the problem might be that the farther you go back in time, the less detail you will get.
One average value for memory consumption over one day, doesn't really give a lot of information I'm afraid.
I would suggest to run this for one day om a daily basis, and that for one week (or more).
The finer granularity of the data should give you a better view on consumption