Filtering on an OR statement

[Anonymous]

I have been away from PowerBI for a few years now so I've forgotten a lot of basics. 

I wanted to show data where a book was published so my filter is, if "Published Date" is entered OR "Online Published Date" is entered then show data.

When I dragged both dates to the filter and selected the first range "Published Date", it filters out the second "Online published Date" to those that fall under "Published Date".

So, can I do this somehow through standard filtering or do need to create a measure to achive this? 

Thanks

[amitchandak · Accepted solution]

@Anonymous , create an independent date table (create date table and do not join with table

Then have measure like

new measure =
var _max = maxx(allselected(Date),Date[Date])
var _min = minx(allselected(Date),Date[Date])
return
calculate( sum(Table[Value]), filter('Table', ( 'Table'["Online Published Date] >=_min && 'Table'["Online Published Date] <=_max) || ( 'Table'["Published Date] >=_min && 'Table'["Published Date] <=_max)   ))