Forum Discussion

Igor_P's avatar
Igor_P
Frequent Visitor
2 years ago

Distribution of Task Budget over Task Period

Hi, I`m rather new to PowerBI and only begin my DAX journey. I understand that my case has been answered several times, but unfortunately i could not adjust provided answeres to my case. My bad, of ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Igor_P ,

Do not have permission to access the link, please check.

 

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

 

Thanks for your efforts & time in advance.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Igor_P's avatar
Igor_P
Frequent Visitor
2 years ago

Hi,

a bit confused how to upload *.pbix here, i'll try to do it a bit later.

As for your questions:

Model Structure is as follows:

 

 

Data: Budget Table:

TaskPeriods Table:

Task and Stage Tables:

Result would be nice to see as below (I give data in form of tables, diagrams will be added after)

 

Yearly Distributed Project Cost/Budget

 

Monthly Distributed Cost/Budget (2024 Year example)

 Also model should allow to make analitics by Stages, Tasks, Periods. Then i would add actual / forecast analysis and so on...

 

Thank you