topic Calculate hours plus the next 30 days in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-hours-plus-the-next-30-days/m-p/4009804#M157725 <P>Hi I'm trying to calculate how many hours are spent on a pro bono rotation.&nbsp;</P><P>&nbsp;</P><P>I have the below measure that calculates the Pro Bono Hours for individuals doing a pro bono rotation.&nbsp;</P><DIV><DIV><SPAN>Pro Bono Rotation =</SPAN> <SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>[Pro Bono]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>F</SPAN><SPAN>ILTER</SPAN><SPAN>(</SPAN><SPAN>W</SPAN><SPAN>FE,</SPAN><SPAN> W</SPAN><SPAN>FE[</SPAN><SPAN>Practice Area Name]=</SPAN> <SPAN>"</SPAN><SPAN>Pro Bono"</SPAN><SPAN>)</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>However, when their rotation is finished they get pro bono hours credit for the next 30 days after their rotatio</SPAN><SPAN>. Rotation periods are as follows;</SPAN></DIV><DIV><SPAN>Jan-Feb</SPAN></DIV><DIV><SPAN>Mar-June</SPAN></DIV><DIV><SPAN>Jul-Sept&nbsp;</SPAN></DIV><DIV>&nbsp;</DIV><DIV>I'm not sure how to write a measure that give them credit for next 30 days follwing their rotation.</DIV></DIV> Tue, 25 Jun 2024 20:54:58 GMT Anonymous 2024-06-25T20:54:58Z Calculate hours plus the next 30 days https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-hours-plus-the-next-30-days/m-p/4009804#M157725 <P>Hi I'm trying to calculate how many hours are spent on a pro bono rotation.&nbsp;</P><P>&nbsp;</P><P>I have the below measure that calculates the Pro Bono Hours for individuals doing a pro bono rotation.&nbsp;</P><DIV><DIV><SPAN>Pro Bono Rotation =</SPAN> <SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>[Pro Bono]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>F</SPAN><SPAN>ILTER</SPAN><SPAN>(</SPAN><SPAN>W</SPAN><SPAN>FE,</SPAN><SPAN> W</SPAN><SPAN>FE[</SPAN><SPAN>Practice Area Name]=</SPAN> <SPAN>"</SPAN><SPAN>Pro Bono"</SPAN><SPAN>)</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>However, when their rotation is finished they get pro bono hours credit for the next 30 days after their rotatio</SPAN><SPAN>. Rotation periods are as follows;</SPAN></DIV><DIV><SPAN>Jan-Feb</SPAN></DIV><DIV><SPAN>Mar-June</SPAN></DIV><DIV><SPAN>Jul-Sept&nbsp;</SPAN></DIV><DIV>&nbsp;</DIV><DIV>I'm not sure how to write a measure that give them credit for next 30 days follwing their rotation.</DIV></DIV> Tue, 25 Jun 2024 20:54:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-hours-plus-the-next-30-days/m-p/4009804#M157725 Anonymous 2024-06-25T20:54:58Z Re: Calculate hours plus the next 30 days https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-hours-plus-the-next-30-days/m-p/4009830#M157727 <P>This post is a dupliate of&nbsp;<A href="https://community.fabric.microsoft.com/t5/Desktop/Calculate-hours-plus-the-next-30-days/m-p/4009803" target="_blank">Calculate hours plus the next 30 days - Microsoft Fabric Community</A></P> Tue, 25 Jun 2024 21:06:33 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-hours-plus-the-next-30-days/m-p/4009830#M157727 foodd 2024-06-25T21:06:33Z