New Column

[Anonymous]

I want to create a column that will display the next value. For example, Beginning Balance of 8/25/2025 should be Ending Balance of 8/22/2025, and so on.

[Praful_Potphode · Accepted solution]

Hi @Anonymous 

try NEXT DAX function in visual calculation.

• You can create Visual calculation by selecting the table visualization.
• CLick on New Visual calculation
• under Home Tab and Select Custom
• Type Below measure

Ending Balance = NEXT([Begining Balance])

Visual Calculation 

please find microsoft link below:

https://learn.microsoft.com/en-us/dax/next-function-dax 

Please give kudos or mark it as solution.

Thanks and Regards,

Praful

[Ashish_Mathur]

Hi,

You have not shared complete information.  How should closing balance be calculated?  Share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

[v-kpoloju-msft]

Hi @Anonymous,

Thank you for reaching out to the Microsoft fabric community forum. Also, thanks to @Ahmedx, @Praful_Potphode, @bhanu_gautam, for those inputs on this thread. I reproduced the scenario again, and it worked on my end. I used it as sample data and successfully implemented it.

outcome:

I am also including .pbix file for your better understanding, please have a look into it.

Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.

[v-kpoloju-msft]

Hi @Anonymous,

Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.

Thank you.

[v-kpoloju-msft]

Hi @Anonymous,

Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

Thank you.

[Ahmedx · Accepted solution]

pls try

[Praful_Potphode · Accepted solution]

Hi @Anonymous 

try NEXT DAX function in visual calculation.

• You can create Visual calculation by selecting the table visualization.
• CLick on New Visual calculation
• under Home Tab and Select Custom
• Type Below measure

Ending Balance = NEXT([Begining Balance])

Visual Calculation 

please find microsoft link below:

https://learn.microsoft.com/en-us/dax/next-function-dax 

Please give kudos or mark it as solution.

Thanks and Regards,

Praful

[bhanu_gautam]

@Anonymous , Try using

DAX
Beginning Balance =
VAR PrevDate =
CALCULATE(
MAX(Balances[Balance Date]),
FILTER(
Balances,
Balances[Balance Date] < EARLIER(Balances[Balance Date])
)
)
RETURN
LOOKUPVALUE(
Balances[Ending Balance],
Balances[Balance Date], PrevDate
)

[Anonymous]

Earlier function not working