Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I am trying to create a data model where I am getting data from multiple sources.
The target is to get Brand & Channel level Income statement from below tables.
Currently I have Sales information at Product and Retailer level in Outlet level sales, in PNL Information tab I have Production Cost and Production volumn; from which I will calculate Production Cost per Unit.
In Trade Cost file, I have trade investment cost in 3 different sheet. In 1 sheet I have Trade cost at Product level, in another one I have Channel-Brand trade cost and in another I have National cost for trade. All this will create Trade investment cost.
Now I have to plot a file where I will be able to see the cost at Brand or Category level with Channel, where I will see Sales Value, Trade Investment and Production cost. For Trade cost at national level, cost to be allocated at a certain ratio I maintain.
Can someone help? Below files are reference.
http://fileshare.link/d78b64b5bc5c7ead/PNL_Information.xlsx
http://fileshare.link/9714dcb4419f4881/ProductHierarchy.xlsx
http://fileshare.link/924e93771e01d259/TradeCost.xlsx
http://fileshare.link/4359396ba52bb515/Outlet_Level_Sales.xlsx
Hi @rajibmahmud,
Could you please show us your desired output with examples? If possible, show us an image to make it more clear.
By the way, I cannot download the file from shared link. Could you please share sample files via OneDrive so that I can download or directly upload the .pbix file with dummy data.
Regards,
Yuliana Gu
I loaded the files in below link
https://1drv.ms/f/s!AuSkszFGzDQzjRuXa9iAHaAZ8UTO
My output would be Sales , Trade investment , Production etc in different layer with option to view in multiple angle. Its a simple PNL format I am looking for.
Can someone please help me with this????
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |