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.
Thanks for this, I've tried to use it but every time I get an error in the EARLIER() function: Parameter is not the correct type. Cannot find name '[InvDate]'.
Hi Mark,
Sorry, is this an error cropping up in the sample file linked, or when you've tried to implement the methods in your own report?
I've just linked it again here in case I'd put it up wrong the first time.
If it's in your own report, would you be able to share the pbix so we can take a look at it?