Re: Price Cost Calculation

giorgionway · ‎12-11-2020

Hello,

can't solve this problem.

got two tables, Purchase Costs and Sales and I want to create report where I can see the price costs of the products.

I got this model in excel and I need in power bi.

giorgionway · ‎12-09-2020

Hello,

can't solve this problem.

got two tables, Purchase Costs and Sales and I want to create report where I can see the price costs of the products.

I got this model in excel and I need in power bi.

MFelix · ‎12-18-2020

Duplicated with:

Regards

Miguel Félix

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

MFelix · ‎12-13-2020

Believe this post is repeated with the one below:

Regards

Miguel Félix

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

ryan_mayu · ‎12-12-2020

just took a look at your sample excel file.

why the qty of sales on 1/3 is 1 not 2? why the qty 4 of 1/14 is under purchase not sales?

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

AllisonKennedy · ‎12-23-2020

@giorgionway Are you able to please answer Ryan's questions or if you have already solved this please let us know how so that others may benefit too.

Thanks!

Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Price Cost Calculation