Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Filter Date Columns Based on Slicer selection

Hi there,   I would like to do something like the "before" option of a slider date slicer but on a single selection Date slicer. This should be done in a Direct Query connection.   I have a table...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Not tested, but see if this can work

measure =
var _date = except(all(TableB[Date]),allselected(TableA[Date]))
return
calculate(countrows(TableB), filter(TableB, TableB[Date] in _date))
Anonymous's avatar
Anonymous
Not applicable
6 years ago

This seems to be working for the example that I presented. Thank you.

 

I oversimplified the problem, only mentioning the date columns. Would it be possible to apply a similar logic to 2 tables that have a different structure? (different set of columns, only the Date one being mutual).