Calculate Gross Merchandise Value
Result—
Formula
Total Value of Goods SoldExcel formula
=B2
Power BI DAX measure
GMV =
SUM(Orders[GrossMerchandiseValue])
Enter your values to calculate Gross Merchandise Value. Use the formula and examples below for Excel, Google Sheets, Power BI, and dashboards.
Useful learning resources related to this page. As an Amazon Associate, this site may earn from qualifying purchases at no extra cost to you.
Total Value of Goods Sold=B2
GMV =
SUM(Orders[GrossMerchandiseValue])