Urgent Help please!!

[Anonymous]

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.

[Anonymous · Accepted solution]

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.

[Greg_Deckler]

@Anonymous You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008