you could try
in 2 separate text boxes (don't know how it is called in sense) and post the result
I am not sure what you meant there.
But below is the code from editor.
LOAD MonthEnd(Date(Floor("Transaction Date"))) as "Report Date"
and then I sum up my sales as follows inside the fact.
,Sum("USD Netflows") as NetFlows
,Sum("USD Inflows") as Inflows
,Sum("USD Outflows") as Outflows
group by [Report Date], Year([Report Date])
This here gives a timestamp like this 08/31/2017 11:59:59 pm. So, although you did use Floor, but MonthEnd changed the date back to timestamp
MonthEnd(Date(Floor("Transaction Date"))) as "Report Date"
On the other hand, this will give you 08/31/2017 00:00:00 am. So, first you find the Monthend (timestamp) and floored and use the date function for formatting.
Date(Floor(MonthEnd("Transaction Date"))) as "Report Date"
When you used the 1st one in set analysis, there are some rounding issues which might have caused you to not see the max month.... but when you used the new definition, no more rounding problems as we got rid of the time portion of the timestamp