Generating a Normal Distribution for Budget by project when given start and 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.