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]
)

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi prashantg364,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng