Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
2 | |
2 | |
2 | |
2 |