Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Detect new item in same column

Hi,   I have a table like this, and I want to identify the new item that Shopper1 got compared to Monday. What would the formula look like in 'New Item' (Column D)? Shopper Day Item New Item...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Anonymous 
    You can set the variable to any days

     

    New column = 
Var Monday_= CALCULATETABLE(VALUES('Table'[Item]),'Table'[Day]="Monday")
Var Tuesday_= CALCULATETABLE(VALUES('Table'[Item]),'Table'[Day]="Tuesday")
return IF(Tuesday_ in Monday_,BLANK(),[Item])

     

    Paul Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous 
You can set the variable to any days

 

New column = 
Var Monday_= CALCULATETABLE(VALUES('Table'[Item]),'Table'[Day]="Monday")
Var Tuesday_= CALCULATETABLE(VALUES('Table'[Item]),'Table'[Day]="Tuesday")
return IF(Tuesday_ in Monday_,BLANK(),[Item])

 

Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.