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

[WMart_AMS]

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

[v-pagayam-msft]

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!

[v-pagayam-msft]

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.

[v-pagayam-msft]

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.

[Mahesh0016 · Accepted solution]

@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!

[lbendlin]

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