Forum Discussion

Resolver II

5 years ago

Solved

Show dates in current Financial Year (only) when comparing YOY

Hi there, Need some help on visuals, I only want to display months in the current financial year up until the current month. I would like to see YOY but the max date must be the current month and th...

Need Help

Axiomite
5 years ago
Thanks Calvin69 for the reply.

Ive managed to solve it by creating a Financial Year Month Number, sorting my date table's month column with Financial Year Month Number.
I then create measures for previous Year -1 and before previous year -2, and obviously Current year.

So the graph then contains the following fields:
Axis is the sorted Month table
Values the measure for current, PY and PY2
I then filter the graph on my date using relative date to only show "is in this" year.

This seems to work. If anyone is interested in a more detailed explanation I am happy to provide more details.

Kind regards

Axiomite

Resolver II

5 years ago

Thanks Calvin69 for the reply.

Ive managed to solve it by creating a Financial Year Month Number, sorting my date table's month column with Financial Year Month Number.
I then create measures for previous Year -1 and before previous year -2, and obviously Current year.

So the graph then contains the following fields:
Axis is the sorted Month table
Values the measure for current, PY and PY2
I then filter the graph on my date using relative date to only show "is in this" year.

This seems to work. If anyone is interested in a more detailed explanation I am happy to provide more details.

Kind regards