Forum Discussion

Frequent Visitor

5 years ago

Solved

Need help with Daily Resource Loading for Production Elements (DAX to calculate load per day)

Hello, From our ERP system I have data on: [Resource Name] (Machine Centre) [Project Name] [Start Date] [End Date] # of [Hrs of Work] required I am trying to make a stacked bar chart that...

amitchandak
5 years ago
nick_SMTC , refer if the blog or my file on similar topic attached after signature can help

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785

value Split between months start end date.pbix167 KB

amitchandak

Super User

5 years ago

nick_SMTC , refer if the blog or my file on similar topic attached after signature can help

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785

value Split between months start end date.pbix167 KB

nick_SMTC

Frequent Visitor

5 years ago

Thanks amitchandak, got the date table working but having trouble with the formulas to assign a volume of work per date. Will continue to work on.

Forum Discussion

Need help with Daily Resource Loading for Production Elements (DAX to calculate load per day)

Related content

calculate cumulative sales for active products

Less resource consumption

Calculating product profit margins

Azure resource graph and KQL

Production Lessons