Trying to get previous month scores for individuals

[aaditya_j15]

I am trying to get previous month scores for individuals. The date is selected from a slicer which I have placed on the dashboard. 

I am using the following code to calculate the values for previous month

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

The formula for score is as follows:

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.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...