Forum Discussion
New Column
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.
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])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
pls try
8 Replies
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
)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])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
pls try
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.
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.
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.
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.
