How to set if year and month not selected and YTD still function ?

[admin11]

Hi All

@dvl_ctaul have provide me below expression :-

YTD_FLEX = CALCULATE (

[SALES_],

DATESYTD('DATE'[Date])

)

which is very fleible , i can have dynamic YTD amount in any year.

My question is , when i not select any year or month , now the table display blank or error. it there a way to make it default as current yr and month ?

Paul

[dvl_ctaul · Accepted solution]

Yes, try this:

YTD_FLEX = 
VAR cyear = SELECTEDVALUE( 'DATE'[Year], YEAR(Now()) )
RETURN
CALCULATE (
[SALES_],
DATESYTD('DATE'[Date]),
'DATE'[Year] = cyear
)

You will need to make sure that you have a year column in your date table to make this work. (This will only consider year, not month)