Forum Discussion

P_P2595's avatar
P_P2595
Helper 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
Helper I
3 years ago

Thanks Ahmedx, that works for me😊.

  • Ahmedx's avatar
    Ahmedx
    Super 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])
    • P_P2595's avatar
      P_P2595
      Helper I
      3 years ago
      Thank you, will try this