Почему в HubSpot на £24,000 показывается £44,000 в Power BI
DEV · 17.11.2026 · 23:56
Команда продаж добавила несколько действий к сделке, что привело к увеличению прогноза. Экспортируя данные из HubSpot в Power BI, можно воспроизвести эту ситуацию.
Оригинал
Why a £24,000 HubSpot pipeline shows £44,000 in Power BI
The sales team added two calls and a meeting to a deal. The forecast went up even though nobody changed the amount. If you export HubSpot data into Power BI, you can reproduce that symptom with three deals and four activity records. Here is a small test you can run in a fresh SQLite session. The data is invented, the deals are open and all three amounts use one currency. WITH deals(deal_id, amount) AS ( VALUES ('A', 10000), ('B', 10000), ('C', 4000) ), activities(activity_id, deal_id) AS (