how to display closing balance of each month as opening balance of next month?

[Aqeelshoukat]

I have 13 month consumer wise data in a table along with date column, I hvae calculated the closing balance for each month and it shows in table correctly but now I want to show the same balance as opening balance for next month . can any one help me doing that?

[v-huizhn-msft]

Hi @Aqeelshoukat,

Have you resolved your issue. If you have, please mark corresponding reply as answer, and welcome to share your own solution. So more people will learn new knowledge.

Thanks,
Angelia

[v-huizhn-msft]

Hi @Aqeelshoukat,

You can create a nother calculated column to get next month value.

Next month=LOOKUPVALUE(Table[month],Table[month],Table[month]+1)

Then in table visual, select the 'next month' field as row, the closing balance as value level, you will get expected result. If this is not want you want, please post sample data for further analysis.

Best Regards,
Angelia