Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Date selection using MAX(Date) is not working

Hello,

 

I have created table in power BI desktop with hard coded dates which contains the last date of each year.

 

I have created measure C as C = MAX(Date). I am using this Date column as slicer.

 

I am using the selected dates all over the reports in measures. Year(C) for comparison.

 

But data is not coming up properly. When i am trying C = DATE(2018,12,31) then its working as expected but not for C(DATE). The Date format is also same.

 

Can anybody help me with this issue.

Custom Visuals
Data Modeling
Reports
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    7 years ago

    Hi Anonymous,

     

    I modify the measure based on your data to return Year(measure) value: 

     

    Measure = var d=IF(ISFILTERED('Table1'[date]),SELECTEDVALUE('Table1'[date]),"No Selection")
    return
    IF(ISFILTERED(Table1[Date]),YEAR(d),BLANK())
     
    Please check if attached pbix file meet your requirement. 

     

    Best Regards,
    Qiuyun Yu 

3 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous,

     

    You can create a measure below to get selected value in the slicer: 

     

    Measure = IF(ISFILTERED('Calendar'[date]),SELECTEDVALUE('Calendar'[date]),"No Selection")

     

     

    Best Regards,
    Qiuyun Yu 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      v-qiuyu-msft

      I tried the above soplution but the data is not getting filtered when i am trying to use it in measure Year(Measure).

       

      I have also attached the data i have entered in Power BI table.

      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Icon for Community Support rankCommunity Support
        7 years ago

        Hi Anonymous,

         

        I modify the measure based on your data to return Year(measure) value: 

         

        Measure = var d=IF(ISFILTERED('Table1'[date]),SELECTEDVALUE('Table1'[date]),"No Selection")
        return
        IF(ISFILTERED(Table1[Date]),YEAR(d),BLANK())
         
        Please check if attached pbix file meet your requirement. 

         

        Best Regards,
        Qiuyun Yu