DAX SWITCH statement with && to pull values in last 365 days

[adoster]

Hello,

I am trying to build a DAX statement that includes an && statement to only include values within the last 365 days.

This statement works (without the 365)

TEST1 = SWITCH (
TRUE(),

'TABLE1'[STATUS] = "OPEN", RELATED ('TABLE2'[OPENVALUE]),

'TABLE1'[STATUS] = "CLOSED", RELATED ('TABLE2'[CLOSEDVALUE]),

BLANK()

)

I am trying to add code so that if the STATUS is OPEN && is in the last 365 days THEN OPENVALUE

TEST2 = SWITCH (
TRUE(),

'TABLE1'[STATUS] = "OPEN" && DATEINLAST365DAYS, RELATED ('TABLE2'[OPENVALUE]),

'TABLE1'[STATUS] = "CLOSED", RELATED ('TABLE2'[CLOSEDVALUE]),

BLANK()

)

appreciate any assistance.

Thanks!

[FreemanZ · Accepted solution]

hi @adoster 

try like:

TEST2 = 

SWITCH (

    TRUE(),

    'TABLE1'[STATUS] = "OPEN" 

     && DATEDIFF(TABLE1[Date], TODAY(), DAY)<=365, 

     RELATED ('TABLE2'[OPENVALUE]),

     'TABLE1'[STATUS] = "CLOSED", 

     RELATED ('TABLE2'[CLOSEDVALUE]),

BLANK()

)

add the DATEDIFF part to the closed part if needed.