Forum Discussion
Most recent and oldest data within a specific time range using a slicer
Hey PatP,
How would you define last entry. If the 2 sends are done on extactly the same time and date, which one should be considered the last?
If you would like to pick the maximum of them then replace the SUM with MAX in the 2 measures
Last Sent = CALCULATE(MAX(Push_Sent[App notification sends]),FILTER(Push_Sent,Push_Sent[Date sent]=MAX(Push_Sent[Date sent])))
First Sent = CALCULATE(MAX(Push_Sent[App notification sends]),FILTER(Push_Sent,Push_Sent[Date sent]=MIN(Push_Sent[Date sent])))
Impactful IndividualHey PatP,
How would you define last entry. If the 2 sends are done on extactly the same time and date, which one should be considered the last?
If you would like to pick the maximum of them then replace the SUM with MAX in the 2 measures
Last Sent = CALCULATE(MAX(Push_Sent[App notification sends]),FILTER(Push_Sent,Push_Sent[Date sent]=MAX(Push_Sent[Date sent])))
First Sent = CALCULATE(MAX(Push_Sent[App notification sends]),FILTER(Push_Sent,Push_Sent[Date sent]=MIN(Push_Sent[Date sent])))
Thank you, this is exactly what I was looking for!
Thanks for your help!
- ChandeepChhabra
You are welcome!