Forum Discussion

howellchrisj's avatar
howellchrisj
Icon for Helper I rankHelper I
4 years ago

Direct Query Date Slicer - Generated SQL is different

I am running into a Direct Query that is taking a while to execute and pull back results when a Date slicer is utilized from the dimDate.Date field.  I currently have the following data model below a...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

howellchrisj , With an independent date slicer , you can try measure like

 

Between dates =
var _max = minx(allselected(Date), Date[Date])
var _min = maxx(allselected(Date), Date[Date])
return
calculate(count(Table[Project Number]), Filter(Table,(Table[EndDate] <=_max && Table[EndDate]) >=_min ) )

howellchrisj's avatar
howellchrisj
Icon for Helper I rankHelper I
4 years ago

amitchandak, thank you for the suggestion and I may have to go with that approach.  Ultimately, I was hoping to leave the data model alone and figure out if I am doing something wrong elsewhere since the underlying SQL generated by PBI changes between the two different fields.