Current Financial Year & Previous Financial Year

[vardhancse]

Hi,

I have one field called [Financial Year]

data for that field was:

FY15

FY16

FY17

Based on selection of Financial Year field, bar chart should display the current year months and previous year months field.

Could any one please let me know the condition for the same.

Tried as below in expression:

Previous Year months:

=Sum({<Month=,Year= {$(= max(Year-1))}>}[Total Cost (actual)])

Current Year Months:

=Sum({<Month=,Year= {$(=max(Year))}>}[Total Cost (actual)])

But no luck in getting as required.

[vardhancse]

Yes Financial Year is a field having data as

FY16

FY17

FY18

[sdmech81]

Can you please replace that max(Year-1) with Addmonths(max(Year),-12)  and check..Try put them in variable.

If not,will pass on better master calendar..

Sachin

[sdmech81]

Can use Addyears()..:)