Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Openingbalanceyear

Hi everyone,   I have a complex formula that calculates specific values for me. One one line of this formula something goes wrong.   The line: OPENINGBALANCEYEAR( CALCULATE( SUM( [VALUE] ) , [D...
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous ,Yes it works like that.

     

    Try

    calculate(firstnonblankvalue(Calendar[Date], CALCULATE( SUM( [VALUE] ) )), allexcept(Calendar, Calendar[Year]))

     

    Discussed here - https://youtu.be/6lzYOXI5wfo

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous ,Yes it works like that.

 

Try

calculate(firstnonblankvalue(Calendar[Date], CALCULATE( SUM( [VALUE] ) )), allexcept(Calendar, Calendar[Year]))

 

Discussed here - https://youtu.be/6lzYOXI5wfo