using SELECTEDVALUE function not able to return date value

[mallik999]

Hi All,

I am using the below DAX Query,i could not able to return required date.

RS returning one date and pu returing another date,based on user selection i want show the date ,but it showing as blank

Could you please help me on this.

[Anonymous]

Hi @mallik999 ,

Sorry to disturb you...

But did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @mallik999 ,

According to my understand, you could add a Slicer for Price_type to realize the step of“select”.

In addition, if you want to calculate the minimum date based on each Price_type, the measure could be abbreviated like this:

m_min_Date =
CALCULATE (
    MIN ( 'ANALYTICS VM_GCP05_Report'[VALID_FROM_GMT_DTM] ),
    ALLEXCEPT (
        'ANALYTICS VM_GCP05_Report',
        'ANALYTICS VM_GCP05_Report'[Price_type]
    )
)

My visualizations look like this:

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please upload some insensitive data samples and expected output.

Best Regards,

Eyelyn Qin

[Greg_Deckler]

@mallik999 This is generally caused by SELECTEDVALUE returning more than one date and if you do not have an Alternate set (last parameter) then you will get this behavior. You can test this by substituting MAXX(...), checking value and then use MINX(...). If you get a different value, there it is.

[amitchandak]

@mallik999 , Very difficult to tell like this.

But I do see any Price type filter and you have used selectedvalue on that. So as of now, there is no selectedvalue. Hence blank.

Can you share sample data and sample output in a table format? Or a sample pbix after removing sensitive data.

[mallik999]

@amitchandak  Thanks for your reply,

its live connection i couldn't able to share the pbix file.

I have field like price type it contains RS and PU

when i select RS i want show as 06/07/2020 when i select PU i want show as 03/07/2020

i have taken individual measures and returning the date information is fine, the problem is i wan show in the single card based on selection of price type for that i have written DAX Query you can see in screen print,but its not returning,don't knwo the reason.

Regards

Mallikarjun

[amitchandak]

@mallik999 , The doubt slicer, I do not see any slicer for Price type; the selected value is failing  Price Type. The way to check, is to return each var one by and check