I'm afraid I'm not privileged to that info.

Customer ID has differing values, all similar to A123 or C883 (etc..). CreditCheckLevel either has the matching CustomerID for that row - hence...

• This reply was modified 5 years, 7 months ago by  chocthree.

Thanks for your reply.

Do you need to do a left join at all. Couldn't you simply use a where clause?  I'm just trying to get my head around if a...

Thank you all for your responses.
There is a winner and that is Jeffrey Williams' post. I had to tweak it slightly to handle the negative values. Jeffrey, I know...

Hi Jonathan,
Using a FULL JOIN in place of an INNER JOIN returns the below dataset:

So it does return some data, however in the Grouping_Level...

Hi John, having tried using COALESCE I find it doesn't achieve what I require. The full query continues to return nothing due to the join not being satisifed and no...

Ok. Thanks.
I don't have visual on the original SQL db so I can only presume the integrity was/is placed throughout. I'm actually guessing that CentreID was a PK. I...

Deleted.

Like the others have said, Power BI is capable of meeting your requirements. However, to host it on-premises you will need to purchase 'Premium Capacity' (PC) which isn't cheap. PC...

Thanks all for your replies.
saravanatn - your post was very helpful. I understood it and applied the logic to cater for the space delimiters too. All works now.

..

Deleted.

Deleted.

Thanks again Dave.
Did you go on to buy other Kimball books or did you find the one you've a photo of the only one you needed to understand the...

Deleted.

Deleted.