Variance between current and last year based on a year slicer from Calendar Table

Anonymous Worked perfectly. thanks so much. I also figured out that if I want to look at the last year current month, I can add the Filter(All(Table1 (date)) 

A proper calendar table is based on a Date column as the primary key, and uses 1:* relationships. Once you have that corrected you can use the standard time intelligence DAX functions.

Hi kalkhudary 

To calculate the variance percentage of calls received based on the last year, you need to ensure that your DAX formula correctly captures the values for the current year and the previous year.

The issue in your formula seems to be with the calculation of , where you are filtering the year directly in the  function. This might not be working as expected because the context transition might not be properly applied.

Try this:

Calls Received Variance % =
VAR Up_Arrow = UNICHAR(9650)
VAR Down_Arrow = UNICHAR(9660)
VAR SelectedYear = SELECTEDVALUE('Calendar Table'[Year-Global Filter])
VAR CallsReceivedCurrentYear =
    CALCULATE(
        SUM('Table1'[Value]),
        'Table1'[Indicator] = "Calls received",
        'Calendar Table'[Year-Global Filter] = SelectedYear
    )
VAR SelectedCallsReceivedLY =
    CALCULATE(
        SUM('Table1'[Value]),
        'Table1'[Indicator] = "Calls received",
        SAMEPERIODLASTYEAR('Calendar Table'[Date])
    )
VAR Difference = CallsReceivedCurrentYear - SelectedCallsReceivedLY
VAR CallsReceivedPercentage = DIVIDE(Difference, SelectedCallsReceivedLY, 0)

RETURN 
    IF(
        Difference < 0,
        "-" & FORMAT(CallsReceivedPercentage, "0.0%") & " " & Down_Arrow & " from LY",
        "+" & FORMAT(CallsReceivedPercentage, "0.0%") & " " & Up_Arrow & " from LY"
    )

If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.

Regards,

Nono Chen

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