Display next 2 period (month)

AtzdGr8
AtzdGr8
in Modeling

Hi everyone. I'm not quite sure if i'm using the correct formula in displaying the next 2 month period.

if I selected Oct 24 in time dimension, the result would be display is Dec 24 in my column.

is used this formula NEXT(NEXT(ITEM(Time))) which is running and no error. Just to make sure if i'm using the correct formula.

Best Answer

  • seymatas1
    seymatas1
    Answer ✓

    Hi @Arth,
    You might want to try this:

    image.png
    image.png

    This way is more efficient. It's a good idea to avoid nested formula statements like NEXT(NEXT(ITEM())) or PARENT(PARENT(ITEM)) to keep your model's performance.

    I hope this helps!
    Şeyma 🌷🙂

Categories