01 · Power BI · DAX · Fabric
Executive business intelligence
The result only shows up when the month is closed.
Filter revenue, cost, margin and cash, and run a materials-cost scenario.
Demo on fictional data — never customer data.
Working simulation on the Noordlicht Techniek dataset. Not a live Power BI report.
- Revenue
- €13,163,157
- Cost
- €9,406,430
- Result
- €3,756,727
- Margin
- 28.5%
- Cash 30 Sep
- €15,530,690
Result by month
- Jan 26
- Feb 26
- Mar 26
- Apr 26
- May 26
- Jun 26
- Jul 26
- Aug 26
- Sep 26
September drops because of PRJ-0087 (€28,000) and PRJ-0142 (€15,000).
| Project | Cost |
|---|---|
| PRJ-0087 | €44,248 |
| PRJ-0142 | €23,250 |
| PRJ-0020 | €14,480 |
| PRJ-0008 | €13,622 |
| PRJ-0017 | €12,246 |
Brutomarge % =
DIVIDE ( [Omzet] - [Kosten], [Omzet] )
Kosten scenario =
[Kosten] + [Materiaalkosten] * [Scenario %]