· 
 · Episode 1

Data Input Measure for Price Simulation

3:48 min

Season 2 opens with pricing. Product selling price average comes from the semantic model, so it averages by month but sums at quarter and year. We fix that with the totals aggregation settings, switching row and column to average leaf. Because a native measure cannot be edited, we then create Price Forecast as a data input measure copied from it, so planners can set the price of every product by product family, channel, city, country and region.


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.