Forum Discussion
MAruna
Helper I
Helper IFinancial Year Data comparison with previous years
Hi Team, I need help on my new requirement. I am using this Final measure : Amount Display = VAR SelectedFY = SELECTEDVALUE(MonthData[FinancialYear]) -- Extract FY start and end VA...
krishnakanth240
Super User
Super UserHi MAruna
Okay, Can you share some dummy data over excel file to work on it.
Also, please share 1.Logic requirement 2.What output you are looking for from visual
If you can explain with an example it would be helpful to understand.
MArunaHelper I
Helper ICurrent Year Amount =
VAR SelectedFY =
SELECTEDVALUE ( FY_Slicer[Financial Year] ) ---- Disconnected Table
VAR OptionSelected =
SELECTEDVALUE ( YearOption[YearOption], "Current Year" ) --- Disconnected Table
VAR DivValue =
SELECTEDVALUE ( 'Display Amount'[Divisor], 1 ) ---- Disconnected Table
RETURN
IF (
OptionSelected IN { "Current Year", "Previous Year" }
&& NOT ISBLANK ( SelectedFY ),
ROUND (
CALCULATE (
SUM ( Month Data[Amount] ),
REMOVEFILTERS ( Month Data[Financial Year] ),
Month Data[Financial year] = SelectedFY
) / DivValue,
2
)
)
Previous Year Amount =
VAR SelectedFY =
SELECTEDVALUE ( FY_Slicer[Financial year] ) ---- Disconnected Table
VAR OptionSelected =
SELECTEDVALUE ( YearOption[YearOption], "Current Year" ) --- Disconnected Table
VAR FY_Start =
VALUE ( LEFT ( SelectedFY, 4 ) )
VAR PrevFYText =
FORMAT ( FY_Start - 1, "0000" ) & "-"
& FORMAT ( FY_Start, "0000" )
VAR DivValue =
SELECTEDVALUE ( 'Display Amount'[Divisor], 1 ) ----- Disconnected Table
RETURN
IF (
OptionSelected = "Previous Year"
&& NOT ISBLANK ( SelectedFY ),
ROUND (
CALCULATE (
SUM ( Month Data[Amount]),
REMOVEFILTERS ( Month Data[Financial Year] ),
Month Data[Financial Year] = PrevFYText
) / DivValue,
2
)
)
This is working fine but here in the legend selection based on the slicers section i need display like if we select 2025-2026 and selected previous year display
2025-2026
2024-2025