SELECTEDVALUE date in measure not working

[Anonymous]

I'm stumped as to why this won't work so hopefully someone can educate me. I am creating a continuity report and would like the user to be able to select an "as at" date which would show a beginning balance, current month additions, current month disposals, etc. The selected date will always be a month-end date so I create a date table with only end of month dates:

EOMTable = 
SUMMARIZE(
    ADDCOLUMNS(
        CALENDAR(FIRSTDATE(v_fixed_asset_transactions[Accounting Date]), LASTDATE(v_fixed_asset_transactions[Accounting Date])),
        "Month Number", MONTH([Date]),
        "Year", YEAR([Date]),
        "EOM", EOMONTH([Date], 0)
    ),
[Month Number], [EOM], [Year])

I've created a measure that separates transactions based on a transaction type and date using a slicer date:

SelectedDate = SELECTEDVALUE(EOMTable[EOM])

Continuity = 
VAR period = DATE(YEAR([SelectedDate]), MONTH([SelectedDate]), 1) 
RETURN
SWITCH(
    TRUE(),
    v_fixed_asset_transactions[Accounting Date] < period
    && (v_fixed_asset_transactions[Type] = "PPE" 
    || v_fixed_asset_transactions[Type] = "INTANGASSETS"
    || v_fixed_asset_transactions[Type] = "GOODWILL"), 
        1, //Beginning cost
    v_fixed_asset_transactions[Accounting Date] > period 
    && v_fixed_asset_transactions[Amount] > 0 
    && (v_fixed_asset_transactions[Type] = "PPE" 
    || v_fixed_asset_transactions[Type] = "INTANGASSETS"
    || v_fixed_asset_transactions[Type] = "GOODWILL"), 
        2, //Additions
    v_fixed_asset_transactions[Accounting Date] > period 
    && v_fixed_asset_transactions[Amount] < 0 
    && (v_fixed_asset_transactions[Type] = "PPE" 
    || v_fixed_asset_transactions[Type] = "INTANGASSETS"
    || v_fixed_asset_transactions[Type] = "GOODWILL"), 
        3, //Disposals
    v_fixed_asset_transactions[Accounting Date] < period 
    && (v_fixed_asset_transactions[Type] = "ACCDEPRECIATION" 
    || v_fixed_asset_transactions[Type] = "ACCAMORTIZATION"), 
        4, //Beginnging depreciation
    v_fixed_asset_transactions[Accounting Date] > period 
    && (v_fixed_asset_transactions[Type] = "ACCDEPRECIATION" 
    || v_fixed_asset_transactions[Type] = "ACCAMORTIZATION"), 
        5, //Monthly depreciation
        0 //Other
)

This does not work and puts everything as additions/disposals:

However, if I change VAR period to be "= DATE(2018, 8, 1)" then it works:

Continuity = 
VAR period = DATE(2018, 8, 1) //DATE(YEAR([SelectedDate]), MONTH([SelectedDate]), 1) 
RETURN
SWITCH(
    TRUE(),
    v_fixed_asset_transactions[Accounting Date] < period
    && (v_fixed_asset_transactions[Type] = "PPE" 
    || v_fixed_asset_transactions[Type] = "INTANGASSETS"
    || v_fixed_asset_transactions[Type] = "GOODWILL"), 
        1, //Beginning cost
    v_fixed_asset_transactions[Accounting Date] > period 
    && v_fixed_asset_transactions[Amount] > 0 
    && (v_fixed_asset_transactions[Type] = "PPE" 
    || v_fixed_asset_transactions[Type] = "INTANGASSETS"
    || v_fixed_asset_transactions[Type] = "GOODWILL"), 
        2, //Additions
    v_fixed_asset_transactions[Accounting Date] > period 
    && v_fixed_asset_transactions[Amount] < 0 
    && (v_fixed_asset_transactions[Type] = "PPE" 
    || v_fixed_asset_transactions[Type] = "INTANGASSETS"
    || v_fixed_asset_transactions[Type] = "GOODWILL"), 
        3, //Disposals
    v_fixed_asset_transactions[Accounting Date] < period 
    && (v_fixed_asset_transactions[Type] = "ACCDEPRECIATION" 
    || v_fixed_asset_transactions[Type] = "ACCAMORTIZATION"), 
        4, //Beginnging depreciation
    v_fixed_asset_transactions[Accounting Date] > period 
    && (v_fixed_asset_transactions[Type] = "ACCDEPRECIATION" 
    || v_fixed_asset_transactions[Type] = "ACCAMORTIZATION"), 
        5, //Monthly depreciation
        0 //Other
)

Expected result:

I've confirmed the formula is working by creating a measure:

Measure = DATE(YEAR([SelectedDate]), MONTH([SelectedDate]), 1)

Put this in a table and see this result:

My head hurts from pounding it on the desk. Any ideas?

Thanks in advance. 

[v-danhe-msft]

Hi @Anonymous,

Could you please offer me some sample data or share the pbix file if possible?

Regards,

Daniel He

[Anonymous]

I ended up taking a different route on this. Similar result but not exactly what I was looking for. I'll see if I can scrub the dataset and provide the pbix file for you to review. Thanks for your reply.