Comparar fecha de slicer con fecha de tabla

[EfrenR]

¿Se puede comparar una fecha que esta en un rebanador con la fecha de una tabla? Al crear una medida para esto me genera un error, porque no se puede comparar un texto con una fecha.

Agradezco la colaboracion.

[mahoneypat · Accepted solution]

You can either make both of the columns into Date data type (preferred), or you can use the CONVERT function on your Text value.  For example, if your slicer has the Date values as text, you could use this in your comparison.

CONVERT(SELECTEDVALUE{Table[ColumnWithDateAsText]), DATETIME)

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[amitchandak · Accepted solution]

@EfrenR , Both should be date column. Click on column and check is its data type under column tool, if test change to date

example

measure = 
var _max = maxx(allselected(Date),Date[Date])
var _min = minx(allselected(Date),Date[Date])
return
calculate(sum(Table[Data]), filter(Table,(Table[Start Date]<=_max && Table[Start Date]>=_min )|| ( Table[end Date]<=_max && Table[end Date]>=_min)))

[mahoneypat · Accepted solution]

You can either make both of the columns into Date data type (preferred), or you can use the CONVERT function on your Text value.  For example, if your slicer has the Date values as text, you could use this in your comparison.

CONVERT(SELECTEDVALUE{Table[ColumnWithDateAsText]), DATETIME)

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat