Forum Discussion

John0708's avatar
John0708
Frequent Visitor
7 years ago

Calculate future amounts based on enddate

I want to show the amount of FTE per jobtitel in our organisation on the first of january every year in the future. The amount of FTE per jobtitel will decline because of enddates. If the jobti...
Need Help
jdbuchanan71's avatar
jdbuchanan71
Super User
7 years ago

Hello John0708 

Here is the measure from my sample file.

Count = 
VAR TheDate = FIRSTDATE ( Dates[Date] )
RETURN
    CALCULATE (
        SUM ( MyTable[Amount] ),
        MyTable[End Date] >= TheDate || MyTable[End Date] = BLANK ()
    )

I have a column in my sample file date table which is StartOfYear that I use in the visual. 

  • John0708's avatar
    John0708
    Frequent Visitor
    7 years ago

    Thanks. I will try this.