Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Shubham_joshi1
Regular Visitor

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
1 REPLY 1
JoBI
Resolver I
Resolver I

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)

 

 

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.