DAX formula: sum future months based on the selected month on the slicer

1
votes

I hope you can help me with below matter. I am trying to figure out the DAX formula for the Rest Of Year column (see image with description). Basically if on the month slicer October is selected then this columns should SUM/CALCULATE budget figures for November and December so only the remaining months for the year.

Appreciate your help in this matter.

Thank you.

problem description in the image

1
powerpivotdax

1 Answers

0
votes

You can try something similar to this (adjust to your names). This way you are subtracting Total year values from YTD values, giving you remaining months figures.

RestOfYear =
CALCULATE (
    SUM ( Sales[Budget] ),
    ALLEXCEPT ( 'Date', 'Date'[Calendar Year Number] )
)
    - CALCULATE ( SUM ( Sales[Budget] ), DATESYTD ( 'Date'[Date] ) )