Issue getting Last_Day(`Date`) working properly in mysql query
I have a MySql dataflow that I'm having an issue with. I have this query that I'm working with and I'm trying to pull the latest NumProjects value in each month. In the output, I'm seeing that its showing the latest set of values twice because the values are different (I assume). This winds up throwing my chart off and summing the two numbers together which misrepresents the intended value. Any ideas on how to fix this would be greatly appreciated.
SELECT `NumProjects`, Last_Day(`Date`) AS 'Date', `PhaseName`
GROUP BY `PhaseName`, `Date`
ORDER BY `Date` desc