Forum Discussion
P_P2595
Helper I
Helper Ihow do I get the previous QTR value without date table
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. Strent...
P_P2595Helper I
Helper IThanks Ahmedx, that works for me😊.
Ahmedx
Super User
Super Userhi? 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_P2595Thank you, will try this