Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I have some order tables (below is just a sample ) based on the I need to show few stats
Month | order | total_items | Value | PIN |
2023-JAN | 123 | 12 | 1000 | 400012 |
2023-JAN | 124 | 2 | 50 | 400045 |
2023-JAN | 456 | 5 | 300 | 500067 |
2023-FEB | 652 | 3 | 200 | 408222 |
2022-JAN | 34 | 9 | 500 | 400045 |
2022-JAN | 45 | 1 | 10 | 500067 |
2022-FEB | 50 | 2 | 60 | 506675 |
I need to show(in matrix table chart) the last two months' total items and their total value and along with the same month last year like below
I can display the current two months but I am not sure how to show preYrcount and the value of same month in same row ?
Please provide some direction to display this details in power bi?
NetCount : Total Item count of a month
Netvlaue : Total value of a month
PreYrCount : Total item count of the same month is last year.
Hi,
I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file if it suits your requirement.
All measures are in the attached pbix file.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
8 | |
7 | |
4 | |
3 |