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.

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi Anonymous 

 

use MIN

 

 

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

 

 

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.