Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
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.
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...
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |