Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Urgent Help please!!

Hi All,

 

I have an urgent request as i am trying this from a long time as I am unable to calculate month closing as next month opening to calculate roll over total for next month.

So the Total and line wise totals for Feb should add Jan and so on, i have tried previous period Dax but it is not working for June July and August months as July has no value in my input sheet.

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

     

    Thanks for the reply from Greg_Deckler , please allow me to provide another insight:

     

    You should create date table and try below formula:

     

    M_ =
CALCULATE (
    SUM ( 'Table'[Value] ),
    FILTER (
        ALL ( 'Table' ),
        'Table'[Area] = MAX ( 'Table'[Area] )
            && 'Table'[Date] <= MAX ( 'Table'[Date] )
    )
)

     

     

     

     

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies