how do I get the previous QTR value without date table

[P_P2595]

Input:

Description	Metric	Target	QTR	Value
1. Strenth Of Services	CS	0	QTR1	234
1. Strenth Of Services	CS	0	QTR2	123
1. Strenth Of Services	CS	0	QTR3	345
1. Strenth Of Services	CS	0	QTR4	111
2. Enhance	Communities	0	QTR1	234
2. Enhance	Communities	0	QTR2	123
2. Enhance	Communities	0	QTR3	345
2. Enhance	Communities	0	QTR4	111

Expected Output:

Description	Metric	Target	QTR2 value	Previous QTR Value
1. Strenth Of Services	CS	0	123	234
2. Enhance	Communities	0	123	234

Please note that I have only QTR data and I want to display previous QTR data based on slicer selection. I don't have a date on the table.

[Ahmedx · Accepted solution]

pls try this

Sample PBIX file attached

https://1drv.ms/u/s!AiUZ0Ws7G26RiDlB_QOME_CZvph8?e=ndZcTy

[Ashish_Mathur]

Hi,

My preference would be to create a Date table.  If you wish to take this approach, then please share/clarify the following:

1. Create a year column as well; and
2. Clarify whether Q1 if JFM

[Ahmedx · Accepted solution]

pls try this

Sample PBIX file attached

https://1drv.ms/u/s!AiUZ0Ws7G26RiDlB_QOME_CZvph8?e=ndZcTy

[P_P2595]

Hi Ahmedx,

Hope you are doing well.

Your solution is perfectly working for me but if the current QTR is blank then it's not displaying the previous QTR values but the previous QTR value is there.

Thanks

[Ahmedx · Accepted solution]

pls try this

https://1drv.ms/u/s!AiUZ0Ws7G26RiEGIpccy8NxBw7RT?e=JPXQHT

[P_P2595]

Thanks Ahmedx, that works for me😊.

[Ahmedx]

hi? try this variant

Previous QTR Value = 
VAR _t1 =MAX('Table'[QTR])
VAR _t2 = MAX('Table'[Description])
VAR _LastValue = CALCULATE(LASTNONBLANKVALUE('Table'[QTR],[Sales]),'Table'[QTR]<_t1)
RETURN
_LastValue
-------------------
Previous QTR Value fixed = SUMX(VALUES('Table'[Description]),[Previous QTR Value]) 

[P_P2595]

Thank you, will try this

[P_P2595]

Thanks Ahmedx, Your solution worked for me😊.