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 

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