Dax measure for below problem

[ARUN_DESHPANDE]

Please provide the Closing balance DAX measure

1. Calendar table
2. Inventory transaction fact table with below columns

Posting date date type

Material code type text

Quantity   Int64.type
Amount   Int64.type

Movement type Int64.type

1. Want Daily, Monthly, quarterly, Yearly closing balance  

[wardy912]

Hi @ARUN_DESHPANDE 

Closing Balance :=
CALCULATE(
    SUM(Inventory[Quantity]),
    FILTER(
        ALL(Calendar),
        Calendar[Date] <= MAX(Calendar[Date])
    )
)

This works for Daily, Monthly, Quarterly, and Yearly because the MAX(Calendar[Date]) changes based on the visual’s granularity.

--------------------------------

I hope this helps, please give kudos and mark as solved if it does!

Connect with me on LinkedIn.

Subscribe to my YouTube channel for Fabric/Power Platform related content!