here for each quoteId I have multiple quotes panels.
if I match mandatory panels to quote panels - (using Power query - left join) - if the mandatory panels don't match, i will get nulls for a few panels
here the problem is - when I supply multiple quoteids - for each individual quoteId it's not showing unmatched panels.
it is showing overall quotes with unmatching panels.
can anybody help with this?
so I need mandatory panels - with the filter for quote id's individually - show unmatched rows with blank for each quoteId.
and for the next quoteId also it should work the same. Is there any dax function /logic able to provide? much appreciated