Count, Case, Condition help

[harishgg1]

hi

please see below post

you will get idea

SQL adding extra rows

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. Aler…