Forum Discussion

aditidhooria's avatar
aditidhooria
Frequent Visitor
9 years ago

Filter Report by Max Date

Hello community,   I want to filter my report with the Max date in my Charts whenever user does not select any year. Do I need to write a query or DAX expression for that? Can someone help with pr...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
v-micsh-msft's avatar
v-micsh-msft
Microsoft Employee
9 years ago

Hi aditidhooria,

 

I think this should be achieveable.

We need to write a condition to determine whether the year has been choosen. Fortunately there are DAX function available to use.

ISFILTERED () and HASONEFILTER().

We should use it under the value measure, to determine whether we would use the MAX date.

Formula should be in the format below:

ValueMeasure : = If (ISFILTERED('DateTable'[Year Column]),

                                 FirstDate('DateTable'[Date Column]) and LastDate ('DateTable'[Date Column]), 

                                 Max('DateTable'[Date Column]))

//Here are only list some date functions that we should take use in the measure, while the formula differs in different situations.

If you could provide some data sample, then we should be able to share a workable measure.

Regards