Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
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.
https://1drv.ms/u/s!Aucu3BmZNQw-p91n7YeUtylfsq2Fqw?e=v1npLa
Duplicated with:
https://community.powerbi.com/t5/Desktop/Price-Cost-Calculation/m-p/1546062
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @giorgionway ,
Believe this post is repeated with the one below:
https://community.powerbi.com/t5/Desktop/Price-Cost/m-p/1541392
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Portuguêsjust 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?
Proud to be a Super User!
@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!
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 38 | |
| 36 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |