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
AjithPrasath's avatar
AjithPrasath
Icon for Resolver II rankResolver II
3 years ago

Hi VisalSeng ,

  Please use the below formula in the new column

=
CALCULATE(
MIN(Data[Product ID]),
ALLEXCEPT(Data, Data[MasterItem])
)

 

PS: Please give kudos and mark this as the solution, if the answer is correct.

VisalSeng's avatar
VisalSeng
Frequent Visitor
3 years ago

AjithPrasath 

 

Sorry for late reply. 

I try your code but it doesn't correct as result I want yet. So any recommend more?