Count events that happend yesterday

[Anonymous]

Hi EXperts

See atatched sample data

https://www.dropbox.com/s/olsw2tlpcxubwnn/SampleData.pbix?dl=0 

I want to could the number of items that happened yesterday, i have tried to use the realted Date in the table visual set to in in the last 1 day and its not working....

So measurs is nexct option.

[amitchandak · Accepted solution]

@Anonymous , On of date id 2021 and another one is from 2020, that is why previousday or any other formula is not working.

refer for last non continous day 

Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9