YTD & PYTD with April as first Fiscal Month

I’m confused as you mentioned you wanted this by financial week number (and that’s what the formula is set up for) but then you’re showing me a table with the Date ? You would need a different formula for that…so what is it that you need?

I would cut your date table down. Just wasted space going out that far. You can do that in the query editor.

1 Like