Forum Discussion

selpaqm's avatar
selpaqm
Icon for Helper V rankHelper V
3 years ago
Solved

Find previous manufacturer

Hi,   having a table as summarized below.  Supplier item shipment date Unique Desired Result aaaa 11111 01/08/2023 aaaa-11111 First Supplier bbbb 22222 03/08/2023 bbbb-22222 F...
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    Is this what you are looking for?

     

    Column = 
VAR _MinDate = CALCULATE(MIN('Table'[shipment date]),ALLEXCEPT('Table','Table'[item]))
VAR _items = CALCULATE(MIN('Table'[upplier]),ALLEXCEPT('Table','Table'[item]),'Table'[shipment date]=_MinDate)

RETURN
IF(_items =[upplier],"First Supplier",_items)

     

     

Semaj06's avatar
Semaj06
Regular Visitor
3 years ago
Previous supplier =
VAR datepivot = Feuil1[shipment date]

var result=
    IF (
        CALCULATE (
            COUNTROWS ( Feuil1 ),
            Feuil1[shipment date] < datepivot,
            ALLEXCEPT ( Feuil1, Feuil1[item] )
        ) = 0,
        "First supplier",
        CALCULATE (
            MAX ( Feuil1[Supplier] ),
            Feuil1[shipment date] <EARLIER(Feuil1[shipment date]),
            ALLEXCEPT ( Feuil1, Feuil1[item] )
        )
    )
return
result