Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 5 | |
| 5 | |
| 5 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 24 | |
| 21 | |
| 15 | |
| 12 | |
| 10 |