Daily Sum per maximum timestamp in Direct Query mode

The attached EXCEL file (https://1drv.ms/x/s!AtFzkZbNpTaFgZYl0EVds1922O48_w?e=Ug3bPo) is PV energy production pasted from a SQL server database. The columns with Red Headers are those I want to calculate and connect to a calendar table for reporting purposes. Being a newbie I can't achieve this in DAX, especially in Direct Query mode due to known restrictions.

Any help appreciated.