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.
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 the PBIX.
You can also 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.
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.