Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Good Day,
I have created the following measure to calculate the closing balance for each month, since the closing balance isn't necessarily on the last day of the month,
Will the formula work if the closing balance of the previous month is not the very end of the month, but just the last day for which there is a balnce calculated?
Hi, @amitchandak
I tried it,
@kristenk14 , use openingbalancemonth month
refer openingbalancemonth,openingbalancequarter, openingbalanceyear : https://youtu.be/6lzYOXI5wfo