topic Re: DAX measure to show current and previous score based on selected reporting period in DAX Commands and Tips

DAX measure to show current and previous score based on selected reporting period

WMart_AMS — Fri, 14 Mar 2025 12:21:20 GMT

Hi Everybody,

Hopefully somebody can help me out. I want to create a DAX measure with which i can present overall scores on project performance. In summery i'm looking for these results, based on the data set you'll find below

Overall_score of current period, based on selected period
Overal_score of previous period, based on selected period
The value should be dynamic based on the selected report period.
Example: selected period is February, so I want to se the overall_score of February and January. If I select January as period, I want to see the overall_score of January and December.

I've tried to work with things like MAX and Rank Columns, but I does not give the the functionalities i'm looking for. I feel like the solution should be simple, but I can't find it.

Your help is greatly appriciated!

The end result should be a table similar like this one:

Index	RANK COLUMN	Project_code	Overall_Score	Current Status	Results previous period	Expected developments
1	5	7304100171	2,25	text	text	text
2	4	7304100171	2,25	text	text	text
3	3	7304100171	2,5	text	text	text
4	2	7304100171	2,5	text	text	text
5	1	7304100171	2,5	text	text	text
1	5	7304210056	1,75	text	text	text
2	4	7304210056	1,75	text	text	text
3	3	7304210056	2,25	text	text	text
4	2	7304210056	2,5	text	text	text
5	1	7304210056	2,25	text	text	text

Re: DAX measure to show current and previous score based on selected reporting period

lbendlin — Fri, 14 Mar 2025 20:15:38 GMT

Please provide sample data that fully covers your issue - including the periods.
Please show the expected outcome based on the sample data you provided.

Re: DAX measure to show current and previous score based on selected reporting period

Mahesh0016 — Mon, 17 Mar 2025 13:06:03 GMT

WMart_AMS I hope the below Dax helps you.

Write Dax:

Overal_score_of_previous_period = CALCULATE( SUM(ScoreTable[Score]), PREVIOUSMONTH('DateTable'[Date]) )

WMart_AMS if this dax helps you please mark as solutions.
Thank You!

Re: DAX measure to show current and previous score based on selected reporting period

Anonymous — Fri, 11 Apr 2025 10:41:10 GMT

Hi WMart_AMS ,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members in the community who have similar problems as yours to solve it faster.

Thank you.

Regards,
Pallavi.

Re: DAX measure to show current and previous score based on selected reporting period

Anonymous — Tue, 22 Apr 2025 11:44:34 GMT

Hi WMart_AMS ,
I just wanted to kindly follow up to see if you had a chance to review the previous response provided by community members. I hope it was helpful. If yes, please Accept the answer so that it will be helpful to others to find it quickly.
Thank you.

Re: DAX measure to show current and previous score based on selected reporting period

Anonymous — Fri, 25 Apr 2025 08:51:32 GMT

Hi WMart_AMS ,
We haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.
If our response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful.
If you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!