Google Sheets Query - using another query to filter dates

I have the following datasource in a GoogleSheet:

Using a QUERY function, I want to get the BALANCE when PROJECTED is TRUE for the MAX DATE per MONTH. The expected outcome should be the following:

My initial approach was the following formula:

=QUERY('2025'!A2:C,
"SELECT MONTH(Col1)+1, MAX(Col1), SUM(Col3)
WHERE Col2=TRUE  
GROUP BY MONTH(Col1)
LABEL MONTH(Col1)+1 'Month', MAX(Col1) 'Max Date', Sum(Col3) 'Balance'")

Then I realized I needed another WHERE condition over Col1 to pull Col3 data based on that. I defined the following query:

=QUERY('2025'!A2:C,
"SELECT MAX(Col1)
WHERE Col2=TRUE
GROUP BY MONTH(Col1)
LABEL MAX(Col1) '' ")

The outcome was:

In order to be inserted as value in the original query, I need to apply a format condition to literal, as follow:

=TEXT(QUERY('2025'!A2:C,
"SELECT MAX(Col1)
WHERE Col2=TRUE
GROUP BY MONTH(Col1)
LABEL MAX(Col1) '' "),
"yyyy-MM-dd")

But the outcome was the following:

What happened with the other two lines for Feb and March?

At the end, the final query, should look like this one:

=QUERY('2025'!A2:C,
"SELECT MONTH(Col1)+1, MAX(Col1), SUM(Col3)
WHERE Col2=TRUE  
AND Col1 MATCHES DATE '"&TEXT(QUERY('2025'!A2:C,"SELECT MAX(Col1) WHERE Col2=TRUE GROUP BY MONTH(Col1) LABEL MAX(Col1) '' "),"yyyy-mm-dd")&"'
GROUP BY MONTH(Col1)
LABEL MONTH(Col1)+1 'Month', MAX(Col1) 'Max Date', Sum(Col3) 'Balance'")

But I'm getting the following:

What happened with the other two lines for Feb and March?

I don't think there's a straightforward way to solve this problem using exclusively the QUERY function.

Here's what you can try instead:

=ARRAYFORMULA(LET(
   data, A2:C,
   max_dates, QUERY(data,
     "SELECT MAX(Col1)
      WHERE Col2 = TRUE
      GROUP BY MONTH(Col1)
      LABEL MAX(Col1) ''"
   ),
   VLOOKUP(max_dates, {data, MONTH(data)}, {4, 1, 3}, )
 ))

This formula first finds the max dates using a simple query, then it runs a vlookup on them to get the corresponding balances.