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 III want to summarize a table with only filtered day/time rows.
FreemanZ
Super User
Super Userhi 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] ) - FreemanZ
from table1 to table2, you don't need to summarize, just filter it, like:
Measure =FILTER(TableNameTableName[Work Order Date]=DATE(2023,4,10))or?