Take latest data conditional on source

Hi,

Try something like this:

var _date = MAX('Calendar'[Date])
var _latestdate = CALCULATE(MAX('Table'[Date]),ALL('Table'[Date]),'Table'[Date]<=_date)
Return

CALCULATE(SUM('Table'[qty]),ALL('Table'[Date]),Table[Date]=_latestdate)

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

Hi Javierco,

Please Try This measure And let me know your Answer.

My Measure =
VAR _latest =
       MAX ( 'Table'[Date] )
VAR _2nd_latest =
      MAXX ( FILTER ( 'Table', 'Table'[Date] < _latest ), 'Table'[Date] )
VAR _FilterTable =
       FILTER ( 'Table', 'Table'[Source] IN { "suppliar1", "suppliar2" } )
VAR _Result =
       CALCULATE (
              SUM ( 'Table'[qty] ),
              FILTER (
                  _FilterTable,
                  'Table'[Date] IN DATESBETWEEN ( 'Table'[Date], _2nd_latest, _latest )
              )
        )
RETURN
      _Result

Hi Javierco 
Here is a sample file that contains the solution https://www.dropbox.com/t/G4SVVdi5t5w5tlMS

Basically, you need to create a new calculated column that retrieves the last order date per supplier for each record:

Last Date = 
MAXX (
    FILTER (
        Data,
        Data[source] = EARLIER ( Data[source] )
    ),
    Data[date]
)

Then you can create a simple measure that performs SUMX over a filtered table:

Last Date Qty = 
VAR LastDateTable = 
    FILTER ( 
        Data,
        Data[date] = Data[Last Date]
    )
VAR Result =
    SUMX (
        LastDateTable,
        Data[qty]
    )
RETURN
    Result