Total revenue by month - Power Office V2 SQL Query - Peliqan

Total revenue by month

SQL query for Power Office V2

Calculate the total revenue for each month.

SELECT DATE_FORMAT(invoice_date, %Y-%m) AS month, SUM(total_amount) AS revenue FROM outgoinginvoices GROUP BY month

Power Office V2 data model

Ready to get instant access to all your company data ?

Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.