YoY Variance Report by Month with dynamic header

Hi,

I have created a Year-over-Year (YoY) variance report by month and would like to enhance it with the following features:

1. Add a dynamic header when a year is selected. I tried creating dynamic fields, but I am getting a blank value, and it ends up returning the variable itself as the header.
2. Add a Year-to-Date (YTD) total before the Total row. This should display the total for the previous year, the current year, and the YoY change in units up to yesterday.
3. I want to also see the Totals as is. 

YoY Variance pbix file 

Table = 

Client IDOrder DateItem NumberClient NameClient Request TypeUnits

Calendar =

Var Days = CALENDAR( MIN('Table'[Order Date]),MAX('Table'[Order Date]) )

RETURN ADDCOLUMNS(

    Days,

    "Year", YEAR([Date]),

    "Previous Year", YEAR ( [Date] )-1,

    "Month Number", MONTH([Date]),

    "Month Name", FORMAT([Date], "mmmm"),

    "Year Month Number", YEAR([Date]) * 12 + MONTH([Date]) - 1,

    "Year Month", FORMAT([Date], "mmm yy"),

    "Weekday", FORMAT ( [Date], "dddd" ),

    "Week Number", WEEKNUM([Date]),

    "Week Number of Year",WEEKNUM([Date],21),

    "Week Number and Year", "W" & WEEKNUM([Date]) & " " & YEAR([Date]),

    "WeekYearNumber", YEAR([Date]) & 100 + WEEKNUM([Date]),

    "Is working Day", not WEEKDAY([Date]) in {1,7},

    "Quarter", "Q" & TRUNC ( ( MONTH ( [Date] ) - 1 ) / 3 ) + 1

)

 

Current Year = YEAR(TODAY())

 

CurrYear =

CALCULATE (

    SUM('Table'[Units]),DATEADD('Calendar'[Date],0,YEAR)  

) + 0

 

PreYear =

CALCULATE (

    SUM('Table'[Units]),DATEADD('Calendar'[Date],-1,YEAR)  

) + 0

 

YoY % =

VAR CurrentYearValue = CALCULATE (

    SUM('Table'[Units]),DATEADD('Calendar'[Date],0,YEAR)  

) + 0

VAR PreviousYearValue = CALCULATE (

    SUM('Table'[Units]),DATEADD('Calendar'[Date],-1,YEAR)  

) + 0

RETURN

IF(

    NOT ISBLANK(PreviousYearValue),

    SWITCH(

        TRUE(),

        PreviousYearValue > 0 && CurrentYearValue = 0, -1, -- Case for previous value > 0 and current value = 0

        PreviousYearValue = 0 && CurrentYearValue > 0, 1,  -- Case for previous value = 0 and current value > 0

        PreviousYearValue = 0 && CurrentYearValue = 0, 0.00, -- Case for both values being 0

        DIVIDE(CurrentYearValue - PreviousYearValue, PreviousYearValue) -- Default case using DIVIDE

    ),

    BLANK()

)

 

 

 

Dynamic column header measure 

Current Year = YEAR(TODAY())

Previous Year = YEAR(TODAY())-1

Dynamic Fields = {

    ( SELECTEDVALUE('Calendar'[Year]), NAMEOF('Table'[CurrYear]), 0),

    ( SELECTEDVALUE('Calendar'[Year])-1, NAMEOF('Table'[PreYear]), 1),

    ("YoY %", NAMEOF('Table'[YoY %]), 2)

}

 Dynamic Fields is not gettting value from selectedvalue

 

 

 

 

 

I would appriciate any guidance ! 

Thanks,

RP