Viewing 15 posts - 76 through 90 (of 3,422 total)
Martin,
Oh, like thaaaaaat!!! That's a lot to digest, but I have my Ralph Kimball secret decoder ring working. Makes sense! now to figure out how to create a table function...
June 11, 2024 at 4:14 am
Wow, Martin! Thanks! I understand most of it. The part I was waaaay wrong on is that YES, the changing prices DO get somewhat merged into the "Recipe"/ProductIngredient table. (I...
June 11, 2024 at 3:59 am
Eirikur,
(Oh wait, before I go too far, all of this mess is in DAX/PowerBI... "Run away, run away!" --King Arthur)
What do you mean by Scopes? ISINSCOPE() kinds of scopes? the...
June 11, 2024 at 2:53 am
There's a Sales fact, but that part is easy, once all the dimension stuff is fixed, so I left it out. Product is related to Sales too. I'm just having...
June 6, 2024 at 4:41 pm
I always think of EXISTS as being useful for testing if one table has ANY related records in another. (So the exact records in the related table aren't important to...
May 9, 2024 at 8:11 pm
At least the cert exams when I did them forced me to learn about and use features I didn't know about. That part was super useful.
May 8, 2024 at 7:12 pm
Think I'm gonna bite the bullet and rebuild with sane field types etc and see what happens. =)
But to answer your question, yes - the goal is to take a...
May 1, 2024 at 5:42 am
Oh I get it! (duh!)
split the recipe into two parts in the CTE.
Part 1 is all the ingredients, weights for everything except the starter
UNION ALL
(For each ingredient in the Starter,...
April 30, 2024 at 4:43 am
Oh I get it! (duh!)
split the recipe into two parts in the CTE.
Part 1 is all the ingredients, weights for everything except the starter
UNION ALL
(For each ingredient in the Starter,...
April 30, 2024 at 4:43 am
So does Poolish (a recipe) ALSO have a starter?
No. Poolish / Starter is what the yeast grows in. Not that it matters that much, but Poolish is 50% flour, 50%...
April 29, 2024 at 8:44 pm
yeah, you know, the database version of a weeping sore.
No, I didn't. gotta try that. Okay, seems to be okay now. Thanks for the tip!
April 23, 2024 at 5:00 pm
(I wonder if they can merge these two posts... Drat!)
I think Jeff is right. If I can express the two or three "Starter" recipes as input into another recipe, then...
April 21, 2024 at 4:51 pm
(Yeah, my browser went a bit nuts)
April 20, 2024 at 4:52 pm
Have you even tried using PowerBI? If that doesn't make you hate Microsoft, nothing will. There are bugs in the software that have been there for like 10 years. My...
April 12, 2024 at 3:54 pm
You have that many points and you can't be bothered to post some consumable data?
You could join on
LEFT(TableA[column],8) = LEFT(TableB[column],8)
April 10, 2024 at 4:22 pm
Viewing 15 posts - 76 through 90 (of 3,422 total)