Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more
Hello community,
I want to request all your help to create a dynamic report that contains the following information:
-Name of transaction.
-Value of transaction (current month).
-Value of transaction (previous month).
-Sum Total transactions per month.
-Percentage of difference between the two aforementioned time periods.
The report that I have at this moment is from another application:
Thanks for waching!!
Hi @jracer007,
Could you post your table structures(including the relationships) with some sample/mock data, and the expected result? So that we can better assist on this issue. It's even better to just share a sample pbix file. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. ![]()
Regards
For now I have not started to build my report in the Power BI, what I can do for now is send you my data source.
https://docs.google.com/spreadsheets/d/12Ktr2AZOYpBchRI9Q-J3ycfhB_9iUiODG_pNqOzwjD4/edit?usp=sharing
Thanks.
Pls!!!!
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Check out the July 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 31 | |
| 28 | |
| 24 | |
| 24 | |
| 19 |
| User | Count |
|---|---|
| 44 | |
| 32 | |
| 18 | |
| 17 | |
| 16 |