Forum Discussion

azizshaikh's avatar
azizshaikh
Frequent Visitor
10 years ago

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...
anandav's avatar
anandav
Icon for Skilled Sharer rankSkilled Sharer
9 years ago

Hi ImkeF

Thanks for the formulas. Using your DAX formulas I was able to get the opening and closing balance.

 

I was trying to use the below DAX functgion and couldn't get the opening balance. 

OPENINGBALANCEMONTH(<expression>,<dates>[,<filter>])

Do you have any example how to use the OPENINGBALANCEMONTH function?

Thanks in advance.

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
9 years ago

Unfortunately not as I don't use that function.