Forum Discussion

P_P2595's avatar
P_P2595
Icon for Helper I rankHelper I
3 years ago
Solved

how 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...
Need Help
P_P2595's avatar
P_P2595
Icon for Helper I rankHelper I
3 years ago

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

    • P_P2595's avatar
      P_P2595
      Icon for Helper I rankHelper I
      3 years ago

      Thanks Ahmedx, that works for me😊.

      • Ahmedx's avatar
        Ahmedx
        Icon for Super User rankSuper User
        3 years ago

        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])