Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 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/2023 is not available . so how to find the yerterdays count ? please help me

date of registration Registration count 
1/5/20232
1/6/20232
1/9/20231
Need Help

1 Reply

  • JoBI's avatar
    JoBI
    Icon for Resolver II rankResolver II
    3 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)