Forum Discussion
Solved
Using FILTER to filter a table based on a SELECTEDVALUE(date) does not work
I have a page where I have a date from a table(Table1) selected from a drillthrough. I create a measure: SelectedDate = SELECTEDVALUE(Table[Date]) This measure when inserted into a c...
Hi JSher ,
Can you try to create a measure with below code and use it as filter on your table visual.
FilteredTable = if(max(Table2[Date2])>SelectedDate,1,0)or
FilteredTable = if(format(max(Table2[Date2]),"mm/dd/yyyy")>format(SelectedDate,"mm/dd/yyyy",1,0))
Hi JSher ,
Can you try to create a measure with below code and use it as filter on your table visual.
FilteredTable = if(max(Table2[Date2])>SelectedDate,1,0)or
FilteredTable = if(format(max(Table2[Date2]),"mm/dd/yyyy")>format(SelectedDate,"mm/dd/yyyy",1,0))
This worked! Thank you
I also need to do an = with it so the format version worked for that.
As a note you have a bracket wrong, should be:
FilteredTable = if(format(max(Table2[Date2]),"mm/dd/yyyy")>format(SelectedDate,"mm/dd/yyyy"),1,0)