Last 4 months based on Slicer

[Sri_phani]

Hi, I a dataset which has 16 metrics which is segregated Month on month. My intention is to show the metric score for month selected along that below the score show the score for last 4 month excluding month shown in card. 

Example: September CSAT score is 51.90%, below that graph should show scores for May, June, July, August. 

I have tried this : Solved: Filter 3 months based on slicer selection - Microsoft Fabric Community. But the problem here is I don't have external tools access (Tabular editor) due to organization policies. So, how to do it? 

Is there a way to write single DAX, instead of write one function for each metrics? 

Thanks in advance. 

[Sri_phani]

Hi Greg, 

Here is the complete information as you requested. 

Sample data: 

Start of Month	SITE	AHT INBOUND CONTACTS	AHT CHAT	AHT CRM	FIRST CONTACT RESOLUTION	CSAT
1/1/2023	India	647 Sec	884 Sec	504 Sec	75.50%	59.70%
1/1/2023	Mexico	577 Sec	808 Sec	479 Sec	72.90%	56.40%
1/1/2023	Egypt	446 Sec	683 Sec	475 Sec	76.70%	68.40%
1/1/2023	Lima	629 Sec	879 Sec	417 Sec	75.90%	76.50%
2/1/2023	India	700 Sec	900 Sec	600 Sec	76.50%	60.70%
2/1/2023	Mexico	800 Sec	900 Sec	700 Sec		57.40%
2/1/2023	Egypt	500 Sec	1000 Sec	500 Sec	73.90%	69.40%
2/1/2023	Lima	600 Sec	1100 Sec	900 Sec	77.70%	77.50%

Expected Output: 

Based on selected filters(Month & Site), the card will show the metric score, example: if I select Mexico and Month as April, card will show the April score. But I also want viewers to see the trend (graph below the card value).  This is where I am having issues. graph should show dynamic last 4 months based on month selected. if December is selcted, for the same year "November, October, September, August" values.

From community forum: Solved: Filter 3 months based on slicer selection - Microsoft Fabric Community

I found help but here I need Tabular editor if I want to group the measures. But I don't have access to Tabular editor. How to get the output, do I have to write individual measures now for all the metrics I have? 

[Greg_Deckler]

@Sri_phani Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.