Practical guides written from real consultancy experience implementing Power BI for UK businesses. No fluff—just patterns you can use today.
Step-by-step guide to setting up a custom fiscal year (October–September) in Power BI. Includes complete DAX for fiscal years, months, quarters, and proper sort orders.
Fix alphabetical month sorting (April, August...) with Sort by Column. Covers calendar months, fiscal years (October–September), and troubleshooting common issues.
Fix wrong YTD figures with correct fiscal year-to-date calculations using TOTALYTD. Covers fiscal year-end dates, prior year comparisons, variance analysis, and production-ready DAX measures.
Real fixes for slow reports and large datasets. Covers data model design, DAX optimisation, Power Query query folding, Import vs DirectQuery, and visual design for performance.
Complete guide to setting up GLM 4.7 (Zhipu AI) with Claude Code on Hetzner. Transform your server into an AI development powerhouse with 128k context window.
If you're stuck on fiscal years, YTD calculations, or any Power BI challenge, let's talk. I can help you get it right.
Book a free strategy call