Forum Discussion

JSher's avatar
JSher
Frequent Visitor
5 years ago
Solved

Filter a table using a DateTime measure

Hello,   I am trying to filter a table based on a measure from a DateTime column.   My measure is: Measure = SELECTEDVALUE(Table[DateTimeColumn]) (creates a date/time mesure from another table) ...
General Comment
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi JSher ,

     

    You could create a measure and add it to visual filter, filter out the visual with measure=1.

    Measure = IF(SELECTEDVALUE(SecondTable[ActionDateTime])<SELECTEDVALUE(TimeAction[ActionDateTime]),1,0)

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi JSher ,

 

You could create a measure and add it to visual filter, filter out the visual with measure=1.

Measure = IF(SELECTEDVALUE(SecondTable[ActionDateTime])<SELECTEDVALUE(TimeAction[ActionDateTime]),1,0)

 

Best Regards,

Jay