Creating change in year volume over Fiscal year

[amgedz]

Hello,

I have volumes over 5 FY and I want to visualize them as the difference every fiscal year and set targets.

So the objective is to have column (difference in volumes) and line (targets) chart 

My data is structured this way below

FY	Volume
18/19	100
19/20	40
20/21	90
21/22	200

Targets

FY	Target
19/20	20
20/21	80
21/22	70

The objective is to create a table showing the incremental difference between two values for the FY as below

FY	Incr. change
19/20	-60
20/21	-60
21/22	50

[v-lionel-msft]

Hi @amgedz ,

Has your problem been solved?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amgedz]

thank you so much It is some how working but I don't know why when I apply slicers they don't apply to the measures I have created

[v-lionel-msft]

Hi @amgedz ,

Is this what you want?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@amgedz , Create a common table FY (say Date) with a rank column

New column in FY Table

FY Rank = RANKX(all('Date'),'Date'[FY],,ASC,Dense)

measure examples 
FY Year = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[FY Rank]=max('Date'[FY Rank])))
FY Year = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[FY Rank]=max('Date'[FY Rank])-1))

diff = [FY Year]-[FY Year ]
diff % = divide([FY Year]-[FY Year ],[FY Year ])