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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Anonymous
Not applicable

Calculate hours plus the next 30 days

Hi I'm trying to calculate how many hours are spent on a pro bono rotation. 

 

I have the below measure that calculates the Pro Bono Hours for individuals doing a pro bono rotation. 

Pro Bono Rotation = CALCULATE([Pro Bono],
                    FILTER(WFE, WFE[Practice Area Name]= "Pro Bono"))
 
However, when their rotation is finished they get pro bono hours credit for the next 30 days after their rotatio. Rotation periods are as follows;
Jan-Feb
Mar-June
Jul-Sept 
 
I'm not sure how to write a measure that give them credit for next 30 days follwing their rotation.
1 ACCEPTED SOLUTION
foodd
Super User
Super User
1 REPLY 1
foodd
Super User
Super User

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.