Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
My question is more about visualization. I'm trying to create a table similar to the one below.
Number of orders each month is sum of quantity. But I want to add additional column which is basically the monthly average of each raw. I'm just struggling on how to do so. Appreciate the help.
Item# | Item Description | Jan-21 | Feb-21 | Mar-21 | Apr-21 | May-21 | Jun-21 | Jul-21 | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21 | Monthly Average |
A-123 | Pencil | 5 | 10 | 5 | 25 | 15 | 30 | 10 | 5 | 5 | 10 | 15 | 25 | 13 |
B-321 | Pen | 25 | 15 | 35 | 10 | 45 | 30 | 5 | 10 | 15 | 20 | 25 | 10 | 20 |
D-987 | Papers | 100 | 150 | 75 | 50 | 200 | 250 | 150 | 100 | 50 | 25 | 50 | 100 | 108 |
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
If you have a Calendar Table, then this can be solved. Share the link from where i can download your PBI file.
Hi @Anonymous
You can use any online services like Onedrive, google drive...and then share the link
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi,
You may download my PBI file from here.
Hope this helps.
YESSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS
If your current measure is called "TotalQty" and your YM column is called "Month" in your Date table (for example), you can use a measure expression like this to get your result. Use it in place of your existing measure in your visual, and you will get the average monthly value in the Total column.
Qty = AVERAGEX(DISTINCT(Date[Month]), [TotalQty])
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thanks @mahoneypat . I was keen to know which visualization to use to show similar visualization to the one I showed above.
If I use the "Matrix", I can't add an additional column at the end of the table that will show the row average.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |