Need help with YTD Calculated Column per record field

Hey Anonymous ,

the following measure should do it. I added some explanations what the mesaure is doing:

YTD Measure = 
-- save account and date of current row in a variable
VAR vAccountRow = myTable[cora_acc_code-accountnumber]
VAR vDate = myTable[Period Date]

-- calculate the sum and filter table to off rows of
-- the current year that are smaller or equal to the row date
VAR vResult =
    CALCULATE (
        SUM ( myTable[Sum of Value] ),
        ALL ( myTable ),
        myTable[cora_acc_code-accountnumber] = vAccountRow
        && YEAR ( myTable[Period Date] ) = YEAR ( vDate )
        && myTable[Period Date] <= vDate
    )
RETURN
    vResult