Forum Discussion

VisalSeng's avatar
VisalSeng
Frequent Visitor
3 years ago

Create New Column from Main Product ID

Hi All Member, I want to create new column "ComboID" from main "ProductID" as below example below   We have Papa Blazing Combo (Product ID: 101) and Sub Combo such as Chicken Wing (102) and Pizza ...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

Write this calculated column formula

=calculate(min(Data[Product ID]),filter(Data,Data[MasterItem]=earlier(Data[MasterItem])))

VisalSeng's avatar
VisalSeng
Frequent Visitor
3 years ago

Ashish_Mathur 

 

Sorry for late reply. I try to do as your code but result is different. It is not correct yet.

 

Combo ID =
calculate(min('Sales Table'[Product ID]),filter('Sales Table','Sales Table'[MasterItem]=earlier('Sales Table'[MasterItem])))

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    What is wrong with that result.  Explain clearly.