SQLTeam.com | Weblogs | Forums

SQL adding extra rows


#1

I have a dataset which i need to represent in power bi using matrix visual. Its basically a dataset having one to may relationship. An Organization can have multiple parts,one part can have multiple dates against it and a date us having 6 different order types.

At the end i need to reprsent it in matrix format in power bi. Is there any way to add extra rows in the dataset(i.e. 0 for quantity having no dates against them.(meaning not present in the dataset but required in the final report.

Alert me | Edit | Change type
Question
You cannot vote on your own post
1
I have a dataset which i need to represent in power bi using matrix visual. Its basically a dataset having one to may relationship. An Organization can have multiple parts,one part can have multiple dates against it and a date us having 6 different order types.

At the end i need to reprsent it in matrix format in power bi. Is there any way to add extra rows in the dataset(i.e. 0 for quantity having no dates against them.(meaning not present in the dataset but required in the final report

Link of the file: https://drive.google.com/open?id=1z5iScgQ__2K3r-xKiCUci36xdJRL7ETX

Also please find the excel file containing the sample and expected output in the link:

https://drive.google.com/open?id=1zGSN64vG1S2qloAPKdNf8tlzQWNPvWRI


#2

I'm not going to click on a link like that not knowing what I get. Post the SQL statement using BB markup, create table statement(s) and inserts with sample data, what you've tried and desired output.