Forum Discussion

shafiz_p's avatar
shafiz_p
Icon for Super User rankSuper User
1 year ago

How to reschedule EDD based on production capacity - Power Query

[Power Query] Issue with cumulative sum and capacity logic. I have a product wise capacity table. See below image: I have a OrderDetails table with many column like Customer, Date, Orde...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

1. Power BI is a reporting tool, not a resource management tool

2. Conditional aggregations can only be done in Power Query, not in DAX.

shafiz_p's avatar
shafiz_p
Icon for Super User rankSuper User
1 year ago

As far as I recall, I posted this problem in the Power Query forum. However, I noticed it's showing up in the DAX forum—perhaps I overlooked the title or label.

 

I'm reposting this in the Power Query forum.

 

Thanks.