Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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.
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
10 | |
7 |