Forecast Model convert annual data to week and month

[EnterpriseDNA]

Hello @Nupur. We have a thread with some recommendations from other Power BI users. Hope this helps.

https://forum.enterprisedna.co/t/extending-forecasting-models/3332

Virtual Table of Weekdays between two date columns

I have an interesting challenge that I’m sure there’s a simple solution for, but I haven’t been able to solve it. I have a table from an Azure SQL database which tracks my team’s individual annual goals for billable hours. Different people have different goal amounts, and to further complicate it the goals might change over time. For example, a new hire might have a goal of 5 billable hours per week for their first month, 10 their second month, 15 their third month, etc. The fact table looks as …

Forward Forecasting Techniques in Power BI with DAX