Forum Discussion
Filtering on an OR statement
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
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) ))
1 Reply
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) ))