Hello all,
How to bring the opening and closing balance for a specific customer account @pbix report using @DAX functions?
I have a requirement where the report will be run for a customer and the data range can be anything, it need not be from starting of the year and ending of the year(1st Jan to 31st dec).
The ways which I have tried are
1) OPENINGBALANCEMONTH and CLOSINGBALANCEMONTH DAX function.
2) Adding the index in the data and sorting according to the customer account value. (eg)
@Parinitha_V
Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?
_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Fowmy Thanks for the suggestion, I have attached the sample data and highlighted the values.