Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dax/selectedvalue

Hi,   Measure = IF ( YEAR ( SELECTEDVALUE('Calendar'[Date] )) = YEAR ( TODAY () ) && MONTH ( SELECTEDVALUE('Calendar'[Date] )) = MONTH ( TODAY () ), "Yes", "No" )   can anyone clar...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    Replace SELECTEDVALUE() with MIN().

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi mwegener 

 

Could you please tell me what can i use instead of selected value to get the above requirement. i used values also still my requirement is not working.

 

 

Thank you.

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous  as Ashish_Mathur suggest, use MIN or MAX function to get the single value from the date range.

 

Measure = 
IF (
YEAR ( MIN('Calendar'[Date] )) = YEAR ( TODAY () )
&& MONTH ( MIN('Calendar'[Date] )) = MONTH ( TODAY () ),
"Yes",
"No"
)

 

Depending on how you want logic to work, change MIN to MAX. For example, if you have selected date Aug 01, 2019 to Nov 30th 2019, MIN will return Aug 01, 2019 and will compare against TODAY(),  MAX will return Nov 30th, 2019 and will compare against TODAY()