Forum Discussion
Opening Balance row wise
Hello All, I need a help in my data where i wanted to get the Opening balance of each customer row wise and its being controlled by a report level date filter. eg. If my report level date filter...
Opening Balance Year should work as that is how I do mine:
Start of Year Indemnity Paid = OPENINGBALANCEYEAR([INDEMNITY Paid Amount],'Summary Financials'[Report Eval Date])
You can also confirm this works by dragging over the YEAR attribute in your Calendar Table and checking to see what the Opening balance is across those years to make sure it is accurate.
Another confirmation is to take multiple date in the year and make sure the result is all the same number (opening balance)