Forum Discussion
Anonymous
6 years agoNot applicable
Adding two tabels
Hi
Below 3 fields is there.
Sales price
200 100
Total is :300
Qty
200
300/200
=1.5
i want like this in power bi please help on this.
2 Replies
- az38Community Champion
Anonymous
Column = ([Sales] + [Price])/[Qty]Unfortunately we can not do more for you with such a poor problem explanation.
- v-lili6-msftCommunity Support
hi Anonymous
You could just create a measure as below to get it:
Result = DIVIDE(SUM(Sales)+ SUM(price) ,SUM(Qty))
If not your case, please share your sample pbix file and your expected output.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Regards,
Lin