Forum Discussion
Solved
Aggregate Functions in Power BI
Hi, I'm new to Power BI. I have a table of invoices, e.g.:- InvRef | CustRef | InvDate -------|---------|----------- INV001 | CUST001 | 2019-03-05 INV002 | CUST002 | 2019-03-08 INV003...
- Hi markarcane ,Because there are some limitations in the direct query connection mode:you could create a custom date hierarchy manually. Please create [Year], [Month], [Day] columns first, right-click the original Date column and choose 'New Hierarchy', then, drag [Year], [Month], [Day] columns to place them under [Date] column.Then you can use the clustered column chart to summarize the invoice quantity of each customer every month.You can also refer to my PBIX.You can learn more through this website:Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Create a Clustered column chart that uses a measure and a category. In this example, we're using Units Sold by Product. By default, Power BI creates a chart that sums the units sold (drag the measure into the Value well) for each product (drag the category into the Axis well).
In the Visualizations pane, right-click the measure, and select the aggregate type you need. In this case, we're selecting Average. If you don't see the aggregation you need, see the consideration and troubleshooting section.
Your visualization is now using aggregated by average.
I hope this information helps!
Regards,
Lewis