Forum Discussion
Solved
DATE AND TIME MATCHING WITH ERROR
I have following two tables with date & time table I want to fetch data in table A as shown below TABLE B CODE DATE & TIME INCIDENT ID ENTRY TYPE H12345 01/10/2021 08:00 757...
visittokiran you can create a measure like this and utilize this a visual level filter
_filter = VAR _a =CALCULATE(MAX('table A'[DATE & TIME])) VAR _b =CALCULATE(MAX('table B'[DATE & TIME])) VAR _c = ABS(DATEDIFF(_a,_b,MINUTE)) RETURN switch(true(),_c=30||_c=0,1)
BA_Pete in both data tables there are multiple entried for same code ...