https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Change-in-Overtime-paid/m-p/3045239#M156635 <P>Hi ,&nbsp;</P><P>I have a sample data below :<BR />I need to calculate change in overtime overperiod per staff.</P><P>the rate is changing every year.&nbsp;<BR />for the example : I need to findout what andrew gets more overtime paid this month less or more than previous month.</P><P>I need to use PowerBi to generate this report but I run into the problem in DAX<BR />how can i create dax that multiply hour with the correct rate per type of overtime and per year?&nbsp; (Exmple : overtime 1 hour should multiply by overtime 1 rate)</P><P>I hope someone can help me with this ,<BR />Thank you</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Thu, 26 Jan 2023 14:08:42 GMT Venussuda 2023-01-26T14:08:42Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Change-in-Overtime-paid/m-p/3045239#M156635 <P>Hi ,&nbsp;</P><P>I have a sample data below :<BR />I need to calculate change in overtime overperiod per staff.</P><P>the rate is changing every year.&nbsp;<BR />for the example : I need to findout what andrew gets more overtime paid this month less or more than previous month.</P><P>I need to use PowerBi to generate this report but I run into the problem in DAX<BR />how can i create dax that multiply hour with the correct rate per type of overtime and per year?&nbsp; (Exmple : overtime 1 hour should multiply by overtime 1 rate)</P><P>I hope someone can help me with this ,<BR />Thank you</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Thu, 26 Jan 2023 14:08:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Change-in-Overtime-paid/m-p/3045239#M156635 Venussuda 2023-01-26T14:08:42Z