Calculate hours plus the next 30 days

[Anonymous]

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.

[Anonymous]

Hi @Anonymous 

Can you provide some virtual data and expected results? Please be careful to delete sensitive data. It is best presented in tabular form.

Regards,

Nono Chen

[Anonymous]

Person A. Had a Pro Bono Rotation in the beginning of the Associate Year. Nov-Feb. I need to calculate pro bono hours during the rotation and also the next month when they went back to practice area – Development. The total Pro Bono Rotation hours should be 742

Person B. Had a Pro Bono Rotation Mar- June I need to calculate pro bono hours during the rotation and also the next month when they went back to practice area – Development. The total Pro Bono Rotation hours should be 590 +  July hours

Fee Earner	Nov 23	Dec 23	Jan 14	Feb 24	Mar 24	Apr 24	May 24	June	July
Person A
Pro Bono Rotation	157	157	159	157
Development Practice					112	41	55	68.7
Person B
Pro Bono Rotation					128	167	182	113
Health Practice	7.5	1.5	21.3	9.5

Originally to figure out Pro Bono Rotation I used this measure Pro Bono Rotation = CALCULATE([Pro Bono],

                    FILTER(WFE, WFE[Practice Area Name]= "Pro Bono"))

However this measure does not add the next month