Forum Discussion

Meghanshu's avatar
Meghanshu
Frequent Visitor
6 years ago
Solved

DAX Query for opening balance

Hi All, I have an inventory dataset having daily transactions and would like to calculate opening and closing balances. Snapshot of inventory data is given below.   I have calculated the closing ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Meghanshu , the opening should be 1 less?

     

    Opening= CALCULATE(SUM(Table[Inventory Balance]),
    FILTER(ALL('Date'[Date]), 'Date'[Date] < MAX('Date'[Date])))

amitchandak's avatar
amitchandak
Super User
6 years ago

Meghanshu , the opening should be 1 less?

 

Opening= CALCULATE(SUM(Table[Inventory Balance]),
FILTER(ALL('Date'[Date]), 'Date'[Date] < MAX('Date'[Date])))

Meghanshu's avatar
Meghanshu
Frequent Visitor
6 years ago

Hi amitchandak  

Query works perfectly fine when I change max value to min value it give me first opening transactional value of the month.

 

 

Thanks !!