Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rajibmahmud
Helper III
Helper III

Compiling Data from multiple source to Prepare Report

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

 

3 REPLIES 3
v-yulgu-msft
Employee
Employee

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-yulgu-msft

 

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????

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.