kivlind Contributor

We maintain a date lookup table that we leverage across multiple datasets that tells us the specific things we need to know about our fiscal year, like quarter, week number, prior year, etc. that would be relevant across all dates. It can be a little work to ramp up a table, but the payoff is there. A join on the date…

Dojo is a great place to go when things get 'complicated' for us. Love the multiple solutions that get proposed as well. Great resource!

Thanks!!!

Thanks...not sure how I missed that option...

I think I have the exact same question. See screenshot below for question. I'd like a column that would be 325,965 / 959,627 or 34.0% and so on for each subsequent row.