MAX of dates

[Anonymous]

Hello,

I want to get the max of the two selected dates and flag it as 1 if it is equal to the MAX of the selected date.

Selected dates from the slicer:

Table:

Here in the table of the selected dates i want to flag the smaller date as 0 and latest selected date as 1.

Can you please help

[Fowmy]

@Anonymous 

Is Cross Filtering form (Format Tab> Interaction) enabled between these two visuals? 

[amitchandak · Accepted solution]

@Anonymous , try like
measure =
var _max = maxx(allselected(Date),Date[date])
return
if(max(Table[asofdate]) = _max ,1, 0)

[Anonymous]

Hi,

When i select other dates like as shown in screenshot it does not work:

Here the previous date should show flag as  0 but it is showing as 1:

[Anonymous]

Hi @amitchandak 

I am facing one problem with the solution.

I have selected two dates in my slicer but when i filter the records (example filter applied on a item location code ) present only in the past date using the filter pane the measure returns 1 eventhough i have selected two dates in myslicer.

I get how the measure is working on the basis of data present in the filter and as the visual has only one date it will show as 1.

I want the measure values to be based on the selection in slicer only and not on the visual data.

Can you please help me with that as wothout this my another measure(which uses the date measure too) changes it's value as the user filters further more

[amitchandak]

@Anonymous , check i tried the same

[Anonymous]

Hi @amitchandak 

Thank you for the solution it worked as expected.

Previously i selected only  one filter from the report level filter and that is why i was confused.

But now i understood. Thank you for the help.🙂