Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 P...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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)   ))

amitchandak's avatar
amitchandak
Super User
4 years ago

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)   ))