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 To...
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.

Anonymous's avatar
Anonymous
Not applicable
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.