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 IndividualPatP Hi, adding time is a good idea
After you refresh the pbi file, It will automatically ensure that the largest date (considering time) is picked up and measure will update automatically.
I just added random times to the dates, here is the result
Hope it helps
ChandeepChhabra Thanks! This look like exactly what I'm looking for. The only thing I'm worried about, is if there is two notifications sent at exactly the same time, is there any way to take just the last entry? I would like to make sure I will never display a sum of different numbers.
Thank you again, I really appreciate it!
- ChandeepChhabra
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])))
Thank you, this is exactly what I was looking for!
Thanks for your help!
- ChandeepChhabra
You are welcome!