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
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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