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 slic...
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 

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