Challenge #192: Crane Leasing

[lucysinclair62]

My solution below:

Spoiler

[BS_THE_ANALYST]

Generate Rows coming in to save the day

Spoiler

[dougbaron]

Spoiler

[StellaBon]

Spoiler

Good practice for generate rows using dates

[caltang]

Got it done!

Spoiler

[François_Rs]

Spoiler

Spoiler

[Ed2000]

Spoiler

[subhajit843]

Here it is

[BSilverblatt]

Thanks for the challenge! Here's my solution:

[Shahbaz_analyst]

Spoiler

Interesting thing I learnt about the generate rows tool in this challenge. If your newly created field is a datetime type and your end date field is just a date type the generated rows won't include the last date even if your expression says new field <= end date field. I assume this is to do with the time component not lining up with the end date but it took me a while to figure out why I was getting different amounts of rows using the generate rows function when i updated a field vs creating a new field.