Hello,
I have two tables that both contain a column named [packaging]. The first column is the data from this week (let's call it 'ThisWeek') and the other column is data from the week previous (let's call it 'LastWeek'). Now, some values in 'LastWeek'[packaging]' are 'NONE' (indicating no packaging known yet, fyi). It's possible that we receive info on the packaging of these orders during the week, in which case the same order numbers in 'ThisWeek'[packaging] will state 'CARTONS' or 'BALES'. The records for which the packaging became known are of interest to me.
So, how can I filter or otherwise identify the records that stated 'NONE' in 'LastWeek'[packaging] and something other than 'NONE' in ThisWeek'[packaging]? I thought about using something like 'IF 'LastWeek'[packaging]="NONE" AND 'ThisWeek'[packaging]<>"NONE", TRUE' in a calculated column to find these values but my dax knowledge is limited at best so I don't know how to do this correctly.
If you need clarification i'm glad to oblige. Thanks in advance.
