Forum Discussion
Identifying ISSAME
Hi guys, Needing some help trying to make a measure to identify when a name in one column is linked to two separate values in another. I want to quantify when an Agent both receives and proce...
Anonymous , Did no see ant processed row.
You need to have column like
if(calculate(distinctcount(Table[Type of Change]), filter(Table, [Name of Agent] = earlier([Name of Agent]) && [Type of Change] in {"Received","processes"}
&& [Date] = earlier([Date]))) =2, 1,0)
Anonymous , Did no see ant processed row.
You need to have column like
if(calculate(distinctcount(Table[Type of Change]), filter(Table, [Name of Agent] = earlier([Name of Agent]) && [Type of Change] in {"Received","processes"}
&& [Date] = earlier([Date]))) =2, 1,0)
Thank you 🙂