Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
I have a table that contain all called Transaction with the following fields, Account Number, Volume, Date opened.
I want to create a report in PowerBI such that:
It will display a matrix visual of rows and columns of the Month Name using this scenario:
If 9 accounts were opened in January are they have a total volume of 250, it should display that for January. If 15 new accounts were created in February with total Volume of 200, It should show their total volume for February and should show the total Volume of all the 9 accounts that was created in January for only their February Volume only which is 200. If 18 anew accounts were created in March with total volume of 450, It should show the total volume for March and should show the total Volume of all the 15 accounts that was created in February for only their March Volume only. Also should show the total Volume of all the 9 accounts that was created in January for only their March Volume only.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
72 | |
71 | |
65 | |
42 | |
42 |
User | Count |
---|---|
49 | |
42 | |
29 | |
28 | |
26 |