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] )
FreemanZ
Super User
Super Userhi prashantg364
there are many ways to do so. what do you plan to do with the filtered data?
prashantg364Helper II
Helper III want to summarize a table with only filtered day/time rows.
- FreemanZ
hi prashantg364
supposing you have a value column, try like:
Measure =CALCULATE(SUM(TableName[Value]),TableName[Work Order Date]=DATE(2023,4,10))- prashantg364
My data set
table 1Work 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 likeWork 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
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] )