Hi,
Is there a way to reference the current month value even while using PREVIOUSOF()? Since using iterative dimension is not allowed, is there a way to shift month values so that value returned by PREVIOUSOF() is the current month value instead of previous month?
Solved
Shift months while using PREVIOUSOF()
- Master Author
Best answer by Gigi
Hi there, great question!
Regrettably, the PREVIOUSOF() can’t be shifted to return the current month. It always returns the value from the previous item in the iterative dimension by design.
If you need the current month value, reference the metric directly (without PREVIOUSOF()).
If you’re trying to realign months (e.g., show prior month values in the current month column), use a time-shift approach like SHIFT( (outside of PREVIOUSOF()), depending on your exact setup.
For more information on the PREVIOUSOF() function, check out our Help Centre article.
- Employee
- Answer
Hi there, great question!
Regrettably, the PREVIOUSOF() can’t be shifted to return the current month. It always returns the value from the previous item in the iterative dimension by design.
If you need the current month value, reference the metric directly (without PREVIOUSOF()).
If you’re trying to realign months (e.g., show prior month values in the current month column), use a time-shift approach like SHIFT( (outside of PREVIOUSOF()), depending on your exact setup.
For more information on the PREVIOUSOF() function, check out our Help Centre article.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.