Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have tried to search for other topics regarding this problem, but can't seem to get any of them to work.
I want to find the average amount of units sold per month per SKU in my DATA table.
This is my table
And this is some of the data
Do anyone has a smart way to do this?
hi @RVBIBS
try to
1) add column with this:
It is safest to build a star schema rather than one flat table. You want to add a proper date table, marked as a date table, and you should also have a separate table for your SKUs, which you could create like
SKU Table = SUMMARIZE('Table', 'Table'[SKU], 'Table'[Item name])
Link both the SKU table and the date table in one-to-many relationships to your fact table, and always use columns from these tables on your visuals and in filters and slicers.
You can then create a measure to show the average quantity like
Avg Quantity = AVERAGE('Table'[Quantity])
You can put this measure into visuals with columns from your SKU and date tables and it will show you the averages broken down by whatever you choose.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
26 | |
24 | |
12 | |
11 | |
10 |