latest submitted data over time

I did not get completed. When selected Nov and Dec, you are choosing dec and Jan date. Second, if you are only looking at GT and you need dates from month data needs to be grouped at month, if you need two dates, one from each month. values or summarize need to be used

Try like

Measure = 
var _min_sel = minx(allselected('Table'[Submitted Date]),'Table'[Submitted Date])
VAR MAX_SUBMITTED_DATE = MAX('Table'[Submitted Date])
RETURN CALCULATE((SUM('Table'[Products])/SUM('Table'[Sales]))*1000,values(Date[Month-Year]),FILTER('Table','Table'[Submitted Date]=MAX_SUBMITTED_DATE && 'Table'[Submitted Date]>_min_sel))

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin

Hi Anonymous ,

We can try to use the following measure to meet your requirement:

Measure =
VAR t =
    SUMMARIZE (
        'Table',
        'Table'[Submitted Date].[Year],
        'Table'[Submitted Date].[MonthNo],
        "TotalProduct",
        VAR m =
            MAX ( 'Table'[Submitted Date] )
        RETURN
            CALCULATE ( SUM ( 'Table'[Products] ), 'Table'[Submitted Date] = m ),
        "TotalSales",
        VAR m =
            MAX ( 'Table'[Submitted Date] )
        RETURN
            CALCULATE ( SUM ( 'Table'[Sales] ), 'Table'[Submitted Date] = m )
    )
RETURN
    SUMX ( t, [TotalProduct] ) / SUMX ( t, [TotalSales] ) * 1000

Best regards,