Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Calculated column to attribute customer based on the

Hi   I'm trying to solve the following problem:   I have two tables in my data model:   Dim Customer -> pink column denotes the effect I would like to achieve   CustomerID CustomerEmail ...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago
CustomerSubType =
var e=Customer[CustomerEmail]
var o=CALCULATE(count(Sales[SaleOrderID]),all(sales),Customer[CustomerEmail]=e,Customer[CustomerType]="wholesaler")
return switch (o,0,"B2C","B2B")