i have a problem and hope you can help me: it is about masterdata, there are two tables in my model
- dim_itemtable containing general masterdata
- dim_supplierinfo containing supplier’s information
I would like to create a table with the masterdata’s and 1 column for every supplier information, avoiding multiple lines when creating a table visual,
I am sure, that it is about pivot or unpivot and seemed to be simple but unfortunately I cannot manage.
please find all details in the annexed samplefile
thanks for your help in advance, greeting from austria
suppfile_180720.pbix (53.7 KB)