Dax/selectedvalue

[Anonymous]

Hi,

Measure =

IF (

YEAR ( SELECTEDVALUE('Calendar'[Date] )) = YEAR ( TODAY () )

&& MONTH ( SELECTEDVALUE('Calendar'[Date] )) = MONTH ( TODAY () ),

"Yes",

"No"

)

can anyone clarify why my Measure is giving me NO even after selecting the current month.

ThankYou.

[Ashish_Mathur · Accepted solution]

Hi,

Replace SELECTEDVALUE() with MIN().

Hope this helps.

[mwegener]

Hi @Anonymous 

your slicer returns a range and not one distinct value.

SELECTEDVALUE

Returns the value when the context for columnName has been filtered down to one distinct value only. Otherwise returns alternateResult.

https://docs.microsoft.com/en-us/dax/selectedvalue-function

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

Please give Kudos for support.

[Anonymous]

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]

@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()

[mwegener]

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.