https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-previous-month-scores-for-individuals/m-p/3614152#M139731 <P>I am trying to get previous month scores for individuals. The date is selected from a slicer which I have placed on the dashboard.&nbsp;</P><P><img /></P><P>I am using the following code to calculate the values for previous month</P><P><img /></P><P>As you might notice in the previous screen shot, the calculated values of prevmonth_summ represented in Score Prev Month column is not appropriate as it represent values for December 2023 itself. For reference, the values for November 2023 are as follows</P><P><img /></P><P>The formula for score is as follows:</P><P>Score = Impacts/ Motion Hours + L1TM/ Motion HOurs + TO/ Motion Hours. All values - Impacts, L1TM, TO are different for each operators for each month. All the values are derived from different tables and linked together based on individual names.</P><P>&nbsp;</P> Wed, 03 Jan 2024 22:04:46 GMT aaditya_j15 2024-01-03T22:04:46Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-previous-month-scores-for-individuals/m-p/3614152#M139731 <P>I am trying to get previous month scores for individuals. The date is selected from a slicer which I have placed on the dashboard.&nbsp;</P><P><img /></P><P>I am using the following code to calculate the values for previous month</P><P><img /></P><P>As you might notice in the previous screen shot, the calculated values of prevmonth_summ represented in Score Prev Month column is not appropriate as it represent values for December 2023 itself. For reference, the values for November 2023 are as follows</P><P><img /></P><P>The formula for score is as follows:</P><P>Score = Impacts/ Motion Hours + L1TM/ Motion HOurs + TO/ Motion Hours. All values - Impacts, L1TM, TO are different for each operators for each month. All the values are derived from different tables and linked together based on individual names.</P><P>&nbsp;</P> Wed, 03 Jan 2024 22:04:46 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-previous-month-scores-for-individuals/m-p/3614152#M139731 aaditya_j15 2024-01-03T22:04:46Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-previous-month-scores-for-individuals/m-p/3631591#M140469 <P>Please provide sample data that covers your issue or question <STRONG>completely</STRONG>, in a <STRONG>usable</STRONG> format (not as a screenshot).<BR /><BR />Do not include sensitive information or anything not related to the issue or question. <BR /><BR />If you are unsure how to upload data please refer to <A href="https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank">https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216</A> <BR /><BR />Please show the expected outcome based on the sample data you provided. <BR /><BR />Want faster answers? <A href="https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523" target="_blank">https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523</A></P> Thu, 11 Jan 2024 00:48:35 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-previous-month-scores-for-individuals/m-p/3631591#M140469 lbendlin 2024-01-11T00:48:35Z