Forum Discussion
prashantg364
Helper II
Helper IIFilter 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 ...
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] )
prashantg364Helper II
Helper IIMy data set
table 1
| Work Order | Work Order Date |
| WO1 | 10-04-2023 04:35 |
| WO2 | 10-04-2023 10:00 |
| WO3 | 10-04-2023 12:00 |
| WO4 | 10-04-2023 15:30 |
| WO5 | 10-04-2023 19:30 |
| WO6 | 10-04-2023 20:00 |
| WO7 | 10-04-2023 22:00 |
| WO8 | 09-04-2023 10:00 |
| WO9 | 08-04-2023 09:00 |
| WO10 | 07-04-2023 22:00 |
| WO11 | 09-04-2023 11:00 |
| WO12 | 08-04-2023 15:00 |
| WO13 | 07-04-2023 23:00 |
| WO14 | 09-04-2023 08:00 |
| WO15 | 08-04-2023 16:00 |
| WO16 | 07-04-2023 17:00 |
After filtering the rows for a specific date
I want to create a new table 2 using summarize function
Table 2 looks like
| Work Order | Work Order Date |
| WO1 | 10-04-2023 04:35 |
| WO2 | 10-04-2023 10:00 |
| WO3 | 10-04-2023 12:00 |
| WO4 | 10-04-2023 15:30 |
| WO5 | 10-04-2023 19:30 |
| WO6 | 10-04-2023 20:00 |
| WO7 | 10-04-2023 22:00 |
ERD
Community Champion
Community Championprashantg364 , 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]
)