How do you calculate net sales with Power BI Connector?

1 0 0

Hello everyone,


I am using the Alpha Serve Power BI Connector to build up a Power BI report for the owners of this shopify account. Everything works pretty well, but I can't figure out which field I have to use to calculate the net sales. Shopify offers various fields to calculate the sales amount, but none of them matches 100% with the sales over time statistic shopify offers.

What is used there?

I found out that „presentmentMoneyAmount“ from the table „orders_originalTotalPriceSet“ fits really good, but it is not filled for every month.


I hope one of you knows the solution for this problem. Thank you and happy holidays.



Replies 0 (0)