Forum Discussion
Solved
One filter for two date columns in the same table
Hello, I have this data model where I have the name of the employee in one table (Let's say table A) his employment start date, and the end date in the same table (Table B, Table A and Table B ha...
obuolys123 , On way is independent date table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = minx(allselected(Date1),Date1[Date])
return
calculate( sum(Table[Value]), filter('Table', ('Table'[End Date] >=_min || isblank('Table'[End Date])) && 'Table'[Start Date] <=_max))Also, refer
Or the file attached after signature
obuolys123 , On way is independent date table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = minx(allselected(Date1),Date1[Date])
return
calculate( sum(Table[Value]), filter('Table', ('Table'[End Date] >=_min || isblank('Table'[End Date])) && 'Table'[Start Date] <=_max))
Also, refer
Or the file attached after signature