Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Yesterdays count find

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/...
Need Help
JoBI's avatar
JoBI
Resolver II
2 years ago

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)