Hi, I have 2 tables.
One is revenue with date field, amount and description, the other is expenses with date, amount and description.
I’ve blended them based on dates.
The numbers on line charts and all the graphics are incorrect, out by quite a distance.
I’m certain I’ve trouble shooted it to the date field. All my expenses dates might appear in the same months but not day of month. I’ve been trying to aggregate to this to a June 2022 (instead of 01/06/2022 or 26/06/2022 but I can’t seem to get it to work.
Can anyone help?