Yesterdays count find

[Shubham_joshi1]

Hello All,

how to find yersterday's count for below table :

for your reference data nature is like  in the below table yesterday's count should be 2 for date 1/6/2023 as previous date 1/8/2023 is not available . so how to find the yerterdays count ? please help me

date of registration	Registration count
1/5/2023	2
1/6/2023	2
1/9/2023	1

[JoBI]

Hello,

You can use the following measure:

Yesterdays Count = 
Var __last_date = CALCULATE(MAX('Table'[date of registration ]))
Var __yesterday = CALCULATE(MAX('Table'[date of registration ]), 'Table'[date of registration ] < __last_date)
Return
CALCULATE(SUM('Table'[Registration count ]), 'Table'[date of registration ] = __yesterday)