Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
Solved! Go to Solution.
@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 ))
@amitchandak, I have tried it before, thanks for your answer.
@Greg_Deckler , I do believe it was the problem. Thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |