Forum Discussion

prashantg364's avatar
prashantg364
Icon for Helper II rankHelper II
3 years ago
Solved

Filter rows

I have a data set as shown below. I want to filter my date between 10-04-23 00:00 to 10-04-23 23:59 and keep the rows. how can I do this?? Work Order Work Order Date WO1 10-04-2023 04:35 ...
  • ERD's avatar
    ERD
    3 years ago

    prashantg364 , if you need to use Summarize function, here is the code that might work for you:

    Table 2 =
SUMMARIZE (
    FILTER (
        'Table',
        DATEVALUE ( 'Table'[Work Order Date] ) = DATE ( 2023, 04, 10 )
    ),
    'Table'[Work Order],
    'Table'[Work Order Date]
)