Calculate a new measure based on a date time period

[MohannadSh1996]

Hi, I am calculating a new measure based on a differnent table dateTime value using:

Triggered = ( 
VAR _Cuur_start = MAX(CalculationsTable[Date]) 
VAR _Curr_end = MIN(CalculationsTable[Date]) 
return 
calculate(SUM(SRTriggered[NumberOfEvents]), 
FILTER(SRTriggered, SRTriggered[Date] >= _Cuur_start), 
FILTER(SRTriggered, SRTriggered[Date] <= _Curr_end )))

 
But it just works when the _Cuur_start equals _Cuur_end (1 day period), while it didn't in case of multipe days.

I'd appreciate if someone can help 🙂

[Greg_Deckler · Accepted solution]

Try switching your MIN and your MAX around. Start as MIN and end as MAX

[amitchandak]

@MohannadSh1996 , Try like

Triggered =
VAR _Cuur_start = MAX(CalculationsTable[Date])
VAR _Curr_end = MIN(CalculationsTable[Date])
return
calculate(SUM(SRTriggered[NumberOfEvents]),
FILTER(all(SRTriggered), SRTriggered[Date] >= _Cuur_start && SRTriggered[Date] <= _Curr_end ))

OR

Triggered =
VAR _Cuur_start = MAX(CalculationsTable[Date])
VAR _Curr_end = MIN(CalculationsTable[Date])
return
calculate(SUM(SRTriggered[NumberOfEvents]),
FILTER(allselected(SRTriggered), SRTriggered[Date] >= _Cuur_start && SRTriggered[Date] <= _Curr_end ))

[MohannadSh1996]

@amitchandak, I have tried it before, thanks for your answer.

@Greg_Deckler , I do believe it was the problem. Thank you!