Generating a Normal Distribution for Budget by project when given start anGenerating a Nod end dates
How can I take a table of projects, that features a budget value, and a start and end date, and generate a normalized distribution by month for every project?
Ideally, this would generate a new table that would have Project Name, Date, Percentage Value (or Budget Value) applicable to that month. Allowing you to forecast ahead overall, or drill into individual projects or corresponding project metadata (region, geography, type, etc.)
What's the best approach? It would be fine to implement this in SQL directly, in M code in data transform, or in DAX expression/measure.
If you want to claculate the normal distribution for each project under current data source, I'm afraid you could not do that because there is only single value for each project. Under this senario the parameter standard deviation will be 0 which is not allowed to be used in the formula Norm.Dist().
If my understanding is not correct, you can consider sharing more details about this issue.
Best Regards, Community Support Team _ Yingjie Li If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.