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
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

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