Solved

Changing default distribution method of entered values

Started by Frans · 3 weeks, 4 days ago · 3 replies · 146 views
Frans Participant
3 weeks, 4 days ago

Hi,

I was wondering if it is possible to change the default distribution method of entered values by our planners? Values are, by default, automatically distributed equally across row and column hierarchies:

Thanks.

3 Replies
Accepted answer
Aparna JegannathanLumel Staff
Lumel · 3 weeks, 3 days ago
Best Answer

Hi Frans,

Currently, the distribution works on Trend, Weights, equally.

Distribution method How it works
Equal distribution Splits the entered value equally among the applicable child members.
Weighted distribution Allocates values proportionally using an existing measure, such as previous-year revenue.
Trend-based distribution Distributes values using existing values or trends, where supported.

Read more from Microsoft Official Documentation here.

 

I am curious to understand your use case a little better. Could you please share an example of what you're trying to achieve by allowing planners to control the default distribution method?

This will help us better understand your requirements and explore the available options.

Data Engineer · Oetiker · 1 week, 5 days ago

Hi Aparna,

Thanks for the input! I didn't know this. I've created a distribution rule now which works fine:

In my case I've chosen Budget (BU previous year) as the reference measure for distribution.

Two additional questions.

  1. If there is no reference value (i.e. no budget value) available, the distribution method falls back to 'distribute equally' right?
  2. I've also noticed that values that have already been entered are not affected by new distribution rules. In these cases, I must empty the column first and re-enter the value (or implement the rule before anyone enters values). Is that correct? Just for my understanding.

Thanks again.

 

Aparna JegannathanLumel Staff
Lumel · 1 week, 3 days ago

Hi Frans,
Yes to both and your understanding is correct.

Viewing 3 replies - 1 through 3 (of 3 total)

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.