Viewing 15 posts - 1 through 15 (of 31 total)
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...
May 17, 2019 at 2:45 pm
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...
May 17, 2019 at 2:35 pm
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...
March 20, 2019 at 4:41 am
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...
March 15, 2019 at 10:18 am
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...
March 15, 2019 at 10:05 am
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...
August 24, 2018 at 9:12 am
August 13, 2018 at 8:17 am
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...
June 13, 2018 at 9:21 am
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.
June 7, 2018 at 8:49 am
June 7, 2018 at 7:39 am
April 10, 2018 at 6:08 am
April 9, 2018 at 5:34 am
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...
February 20, 2018 at 8:54 am
February 20, 2018 at 8:17 am
February 16, 2018 at 10:15 am