Table from several datasources

[hnowotny17]

Hello,

I am trying to create sell-out dashboard from several different data sources. (each data source = 1 customer).  

Data sources has database structure, but the structure is not always exactly same. (Cleaned in Power Pivot).

From the data sources I need few important information: Product code, month, year, sell out quantity. (all of the data sources has this information).

Then I have on source with conversion table, which converts product code into category, description, etc – so I use parameter “product code” to create relationship between tables.

As I already used 1 parameter to merge the sources - then I can´t make a table in the dashboard, with “product code” in the row and “sell out quantity” in the columns from all of the customers as it only count “sell out quantity” from only 1 selected customer.  

Does someone has any idea, how to create the table with sell out data from all customers?

Thank you a lot,

Jan N.

[amitchandak]

While you merged, is there some column left out?

Hope you have already explored

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

More options

https://docs.microsoft.com/en-us/dax/crossjoin-function-dax

https://radacad.com/pivot-and-unpivot-with-power-bi

[Caz_16]

Jan,

Its a little hard to follow your explantion. Could you throw a pbix. onto Google Drive or some other sharing platform and reply with the link so someone can take a look at your data model?

Be sure to clean confidential data from the model or just recreate a simple example before uploading. 

[hnowotny17]

Hello,

Thank you @Caz_16 , @parry2k , @amitchandak for your willingness to help me with this case.

I´ve created the file with distorted business data. If anyone will have a moment, I will more then appriciate it. My question about visualisation is inside the file.

https://drive.google.com/file/d/1xEpspWik_4rj8f-GfdzVqIMPcFr4UxNj/view?usp=sharing

Many thanks again for you help.

Have a nice day,

Jan N.

[amitchandak · Accepted solution]

I have done some modeling to create common date, retailer and product code dimension.

Please find the attached solution

Hope this will help.

[hnowotny17]

Dear @amitchandak,

thank you very much for your help.

Your model perfectly helped me to solve my issue.

Again, many thanks and have a nice day!

Jan N

[parry2k]

@hnowotny17 totally agree with @Caz_16 , very hard to follow, provide sample data with screen shots and all the business process/logic you are doing to understand what is going on and also make sure to provide what you are actually looking for.

Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490