Cost Estimating Analysis - An Approach for Estimating Individual Cost based on Total Costs?

[Domenick]

I have a dataset of projects, details, and total costs from which I want to extrapolate the cost of each component of each project. Does anyone have any suggestions on how to start this endeavor?

A good example would be to think of grocery shopping receipts. I have all the items purchased and the total, but I'd like to estimate the cost of each item. My hope is that there is enough data where two receipts are identical except for one item, allowing me to isolate the cost of that item. But I'm not even sure how I would approach that programatically. 

[lbendlin]

That's an interesting premise.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...