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

HI Try this

Previous supplier =
VAR datepivot = Feuil1[shipment date]
RETURN
IF (
CALCULATE (
COUNTROWS ( Feuil1 ),
Feuil1[shipment date] < datepivot,
ALLEXCEPT ( Feuil1, Feuil1[item] )
) = 0,
"First send",
CALCULATE (
MAX ( Feuil1[Supplier] ),
Feuil1[shipment date] < datepivot,
ALLEXCEPT ( Feuil1, Feuil1[item] )
)
)

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

    Hi Semaj06 ,

    thanks for your respond however it is not fit all of the data in the column is first send in my column.