Challenge #80: Slowly Changing Dimensions

[LukaszKarpinski]

My solution below:

Spoiler

[Qiu]

Had difficulty in understanding the real point here.

Spoiler

[KaneG]

I prefer to do this with Joins rather than Multi-Row, as in practice some of the decisions are often pushed to the DB using In-DB tools

Spoiler

I didn't like discarding Bob... but I did in order to match the output

[A2H]

Spoiler

[michael_leoni]

Spoiler

Please see my solution below. 

[ehughes]

Not my most elegant solution but it works

Spoiler

 

[Than_Alien]

My Solution!!

[Hitch]

Here's my attempt

[tammybrown_tds]

Mine feels simpler than the others.  Not sure if that is a bad or good thing.

Spoiler

[JasonHu]

Spoiler

Here is my submission for challenge 80, use multi-row formula tool many times.😂