Sign in to watch this episode

Episodes are free for Fabric Planning Community members.

or
 · 
 · Episode 6
4:34 min

A forecast measure extends time beyond what the semantic model holds. To set up a real-life case, we filter the data to 31 December 2025, then use Model > Forecast to create Revenue Forecast for January to December 2026. The closed period copies Revenue Actual, and the open period is a data input measure pre-filled with 2025 actuals. Hide the closed periods, type 80M into the total, and the value spreads by each cell's weight.


Part of Planning · Season 2

Mastering Measures

View all 10 episodes
Microsoft, Azure, Copilot, Excel, Fabric IQ, Microsoft Entra, Microsoft Fabric, Microsoft Teams, OneLake, Outlook, Power Automate, Power BI and SharePoint are trademarks of the Microsoft group of companies. IBCS is a registered trademark of IBCS Association. All other trademarks are the property of their respective owners.

This community is operated independently by Lumel. Nothing on this site constitutes a representation or warranty by Microsoft.