Forum Discussion
Solved
Table from several datasources
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 ex...
I have done some modeling to create common date, retailer and product code dimension.
Please find the attached solution
Hope this will help.
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