Overview
NextCart Commerce, founded in April 2007, began as a platform for selling affordable goods and premium products. Initially focusing on electronics and household items, it quickly expanded into apparel, luxury goods, and subscription services.
Data from quarter 2 of 2007 until quarter 2, 2013 was collected to visualise and show to stakeholders of the company. However “Gross Profit” and “Premium Gross Profit” were calculated wrongly. Since powerbi was being used to showcase visualisation, I used it’s dax function to my advantage and made sure that “Gross Profit” and “Premium Gross Profit” were shown correctly to the stakeholders.
- Total of Cost: Cost = SUM('Table 1 (Abdullah)'[Ad Cost of revenue]) + SUM('Table 1 (Abdullah)'[Cost of Revenue]) + SUM('Table 1 (Abdullah)'[Genreal and Adminstraive Cost]) + SUM('Table 1 (Abdullah)'[Premium Cost Revenue])+ SUM('Table 1 (Abdullah)'[Research and Development Cost])
- Overall Cost: OverallProfit = [Profit]+[Premium Profit]+sum('Table 1 (Abdullah)'[Ad gross Profit])
- Sum of Cost of Revenue & P.Revenue: Cost of Revenue&P.Revenue = Sum('Table 1 (Abdullah)'[Premium Cost Revenue])+sum('Table 1 (Abdullah)'[Cost of Revenue])
- OverallProfit = [Profit]+[Premium Profit]+sum('Table 1 (Abdullah)'[Ad gross Profit])
- Premium Gross Profit:P.profit = sum('Table 1 (Abdullah)'[Premium Revenue])-sum('Table 1 (Abdullah)'[Premium Cost Revenue])
- Gross Profit:Profit = SUM('Table 1 (Abdullah)'[Total Revenue]) - SUM('Table 1 (Abdullah)'[Cost of Revenue])
- Gross Profit+Premium Profit: Profit+P.Profit = ([Profit])+([Premium Profit])