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)

     

     

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
3 years ago

Hi selpaqm 
What do you mean by the previous supplier?
Can you show what is the desired result?

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

    Hi Ritaf1983 ,

     

    thanks for your respond. I have amended table. can you please check and advise?