Sign in to watch this episode

Episodes are free for Fabric Planning Community members.

or
 · 
 · Episode 8
4:10 min

Discounts shape how many units you sell, so a forecast should account for them. Parameters act as variables and live in the Parameters pane. We create a page-level number parameter called Product Discount, ID discount, shown as a percentage on a 0 to 25% slider in 0.5% steps and visible in read mode. Then we reconfigure the Units Forecast open period formula to Revenue Forecast / (Price Forecast * (1 - discount)). Move the slider and units rise with the discount.


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.