Add yesterday's count in power bi dashboard

[Anonymous]

 I have columns like (registration date) and (registed_by_id). SO , I have to add a card on my dashboard which will indicate yesterday's registration count. please provide your support.

for referance please look the table below

RegistrationDate	registered_by_id
8/7/2022	1
8/7/2022	1
8/7/2022	1
8/7/2022	1
8/7/2022	1
8/7/2022	1
8/7/2022	1

this type of data i have. Help me please

[Kishore_KVN · Accepted solution]

Hello @Anonymous , you can create measure for that.

For example my sample data is as below:

If you want to select dynamically like depends on date selection then the measure looks like below:

Yesterday's Count = CALCULATE(COUNT('Table'[Registration_ID]),PREVIOUSDAY('Table'[Registration Date]))

Output looks as below:

If you want a measure which will picks up previous days count depends on the maximum date in the data then you can try the below measure:

Yesterday's Count Auto = CALCULATE(COUNT('Table'[Registration_ID]),DATEADD('Table'[Registration Date],-1,DAY))

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!