Forum Discussion
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] ) , [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.
Anonymous ,Yes it works like that.
Try
calculate(firstnonblankvalue(Calendar[Date], CALCULATE( SUM( [VALUE] ) )), allexcept(Calendar, Calendar[Year]))
Discussed here - https://youtu.be/6lzYOXI5wfo
1 Reply
- amitchandak
Super User
Anonymous ,Yes it works like that.
Try
calculate(firstnonblankvalue(Calendar[Date], CALCULATE( SUM( [VALUE] ) )), allexcept(Calendar, Calendar[Year]))
Discussed here - https://youtu.be/6lzYOXI5wfo