Sign in to watch this episode

Episodes are free for Fabric Planning Community members.

or
 · 
 · Episode 7
3:31 min

The previous episode built a forecast measure for data input. This one builds a forecast measure from a formula: Units Forecast. For the closed periods, the formula is Revenue Actual divided by product selling price average, both native measures. For the open period, it is Revenue Forecast divided by Price Forecast, rounded to whole units. Change revenue to 81M, or a Bluetooth speaker price to $80 per unit, and Units Forecast updates.


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.