We have two fields containing DEAs for today and yesterday. Need a field that gives DEA that is present in today but not in yesterday along with location name and territory. These DEA are string fields

@Diksha Joshi​ 

You may create a calculated field to use as filter:

{FIXED [DEA]:
//DEA IN TODAY DATA
MAX([Date]=TODAY()) AND
//DEA NOT IN YESTERDAY DATA
NOT MAX([Date]=DATEADD("day",-1,TODAY()))
}

Then, drag this field to the filter shelf and select the true value.

Finally, Drag DEA, location and territory to the rows shelf.

If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.

Regards,

Diego Martinez

Tableau Visionary and Forums Ambassador