Forum Discussion

mallik999's avatar
mallik999
Helper I
5 years ago

using SELECTEDVALUE function not able to return date value

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 b...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

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's avatar
    mallik999
    Helper I
    5 years ago

    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's avatar
      amitchandak
      Super User
      5 years ago

      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