Reply
Anonymous
Posts: 0
Accepted Solution

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.


Accepted Solutions
Highlighted
Moderator
Posts: 9,181
Registered: ‎03-06-2016

Re: Date selection using MAX(Date) is not working

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 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Attachment

All Replies
Moderator
Posts: 9,181
Registered: ‎03-06-2016

Re: Date selection using MAX(Date) is not working

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")

 

q2.PNG

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Posts: 0

Re: Date selection using MAX(Date) is not working

[ Edited ]

@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).

TableData.PNG

 

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

Highlighted
Moderator
Posts: 9,181
Registered: ‎03-06-2016

Re: Date selection using MAX(Date) is not working

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 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Attachment