topic Re: Calculate hours plus the next 30 days in DAX Commands and Tips

Calculate hours plus the next 30 days

Anonymous — Tue, 25 Jun 2024 20:54:55 GMT

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.

Re: Calculate hours plus the next 30 days

Anonymous — Wed, 26 Jun 2024 03:01:46 GMT

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

Re: Calculate hours plus the next 30 days

Anonymous — Thu, 27 Jun 2024 14:58:20 GMT

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