Forum Discussion
Help needed with DAX measure - Quick
Looking for help with DAX I have a measure [Homes Completed] which calculates the number of homes completed by the completion date dim_date table is connected to the completion date I have a d...
amitchandak
Super User
Super UserSaurabh129 , Created a disconnected date table, do not join with date of you table and then have measure like
Completed before selected=
var _max = maxx(allselected(Date), date[Date])
return
countrows(filter(Table, Table[End Date] < _max))