Forum Discussion
Using time slicer for 2 dates
When you have 2 date columns, the complexity goes up. One option is to have 2 slicers, one for start date and the other for end date (just use a drop down list for both). You need to write a dax measure to manage the filtering on both columns. Something like this would work.
Total hours = calculate([total hours],filter(table, table[start date] >=selectedvalue(table[start date]) && table[end date] <=selectedvalue(table[end date])))
When you have 2 date columns, the complexity goes up. One option is to have 2 slicers, one for start date and the other for end date (just use a drop down list for both). You need to write a dax measure to manage the filtering on both columns. Something like this would work.
Total hours = calculate([total hours],filter(table, table[start date] >=selectedvalue(table[start date]) && table[end date] <=selectedvalue(table[end date])))