Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Everyone, I have 3 columns in my table Debit, Credit and NetBalance(Debit+ Credit). I want to calculate the Opening and Closing Balance.
Kindly suggest the ways to do it.
Best Regards,
@Anonymous , difficult to say without data, but refer if these can help
closingbalancemonth ,closingbalancequarter, closingbalanceyear and lastnonblankvalue
openingbalancemonth,openingbalancequarter, openingbalanceyear and firstnonblankvalue
Hi @Anonymous
Can you please provide more info with input and required output in table format.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |