Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

DAX Calculation




I am working in building a TOP DOWN for  a finance company

Input CSV has few column names like Account_No,Year,Month,Credit,Debit

With this we need to calculate closing balance

CLOSING BALANCE= Opening Balance + (Abolute of Debit amount -Absolute of credit amount)

we have credit and debit but we dont have opening balance(In table)

OPENING BALANCE =Previous months closing balance

For EX: Lets consider Opening Balance of january is 0, we can find the closing balance of january .

So now Closing Balance of january is openning balance of Febuary

**I have attatched a image representing the same****

Can we do this calculation in power Bi using DAX?


Here i have 150 Account ID ,each has 12 months ,for each month we need to find closing balance wrt Account IDCLosing bal opening balance.png


Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors