Hi Everyone. I am making a Financial Dashboard for Fashion Company. I am facing problem in making income statement to transform the raw data. I have unpivoted the cost columns(Printing, Stitching & Fabric Cost) against the order id & order date. But how do i calculate and put the values against B2C Sales, Returns, Refunds and Cancellations?
Data.xlsx (40.3 KB) Income Statement.pbix (349.0 KB)
Please see the income statement format, Raw Data in Excel and Power bi File where i tried to transform the data.
Please let me know what i am doing wrong.