Openingbalanceyear

[Endurion]

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] ) , [DIMENSION]="LY") , 'Calendar'[Date])

This return the closing balance of 31-12 but I need the ballance at 1-1. I know there is a option to define the date within the formule but on this form and other pages I could not find how.

[amitchandak · Accepted solution]

@Endurion ,Yes it works like that.

Try

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

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