Compare previous year data in KPI

[Darren1]

I am working to create a KPI that compares the previous years results to the current selected year.  The user will be able to pick a fiscal year from a filter pane and see the results. However I am having trouble when the first available year is picked (ex 2005) does not have a previous year to compare it to (no data for 2004) . Can the KPI display a text note when a previous year comparison is not available? 

Here is my current expression

Sum({$<fiscal_year={$(=max(fiscal_year))}>} Tons) - Sum({$<fiscal_year={$(=max(fiscal_year)-1)}>} Tons)

[rubenmarin · Accepted solution]

Hi, maybe adding a condition to check if the firts year has been selected, something like:

If(max(fiscal_year)=min({1} fiscal_year), 'text note to display', [YourCurrentExpression])

[Darren1]

Thank you for your response. Your expression help did the trick!