Forum Discussion
Sum Start End Time Column
Hi there! I have two tables and would like to sum between the start and end times. My data is hourly like so: Table1 Date Value 7/18/18 7:00 PM 1 7/18/18 8:00 PM 1 7/18/18...
Anonymous,
You may use DAX below to add a calculated column.
Column = SUMX ( FILTER ( Table1, Table1[Date] >= Table2[Start] && Table1[Date] < Table2[End] ), Table1[Value] )
Anonymous,
You may use DAX below to add a calculated column.
Column =
SUMX (
FILTER ( Table1, Table1[Date] >= Table2[Start] && Table1[Date] < Table2[End] ),
Table1[Value]
)
This worked perfectly, thank you. Can you please provide it as a measure too?