Forum Discussion
Solved
How to use slicer date to compare multiple date columns for correct result
Hi! I have the following sample data below. When I click a date in the slicer I would like to have the following conditions to bring back the correct results for uncommitted based on the receive...
kjanse , Date slicer should be independent date table
//Date1 is independent Date table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
return
calculate(sum(Table[Amount # ]), Filter(Table, Table[Received Date] <= _max && (isblank(Table[Committed Date]) or Table[Committed Date] >= _max)))or check Active employee here
Thank you both! amitchandak I was able to get the results I was looking for with your response.
Thank you again!