Adding to the total value of invoices, the stock value only in this month.

[MichalB]

Hello,

I have a problem with creating a DAX formula with filtering. I have a table as below and the idea is to add the value of yet uninvoiced stock items to the latest value in the row with year 2023 and column with month 1. The invoice table is 'HM DK', the values I add in this column according to month and year are 'HM DK'[Gross], while in the newest cell this year, this month I would have to add the table 'HM TR'[Value] and from it all the items occurring in this month. Both the 'HM DK' and HM TR tables also contain a [Date] column. For now, my formula adds the same value (the sum of 'HM TR'[Value]) to all values, from all months.
Thank you very much in advance for your help.