Forum Discussion
Solved
Measure by Slicers data Selected and Filter DATE between two Fields that have two Relationships
Hi , I hope you are doing great. I need to create a Measure or any solution similar for to have in a Card the next calculation: The Selected DATE taken from two Slicers Year, Month must be less...
You will need to define what you mean by "before" and "after". Your calendar table has day level granularity yet your slicer is only going to month level.
So - Date 1 is less than the MINIMUM selected date and Date 2 is empty of greater than the MAXIMUM selected date?
Also, your table relationships are not needed in this scenario. You can make both inactive.
Id_Before_Date_Selected = var mind = minx(Cal,[Date]) var maxd = maxx(Cal,[Date]) var a = filter(tb_employees,[Date1]<mind && COALESCE([Date2],dt"2030-12-31")>maxd) return COUNTROWS(SUMMARIZE(a,[id]))
lbendlin
Super User
Super UserYou will need to define what you mean by "before" and "after". Your calendar table has day level granularity yet your slicer is only going to month level.
So - Date 1 is less than the MINIMUM selected date and Date 2 is empty of greater than the MAXIMUM selected date?
Also, your table relationships are not needed in this scenario. You can make both inactive.
Id_Before_Date_Selected =
var mind = minx(Cal,[Date])
var maxd = maxx(Cal,[Date])
var a = filter(tb_employees,[Date1]<mind && COALESCE([Date2],dt"2030-12-31")>maxd)
return COUNTROWS(SUMMARIZE(a,[id]))