cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Re: FIRSTDATE and LASTDATE

Hello Xiaoxin Sheng,

 

The way I want it to work is as follows:

- With the slicer a date range is selected. For example, 01-01-2017 through 31-12-2017.

- I now want the average per group from the scores with a FIRSTDATE within this date range and the average per group from the scores with a LASTDATE within this date range.

- If an ID has multiple scores on the same FIRSTDATE or LASTDATE that should first be averaged before the group average is calculated.

 

The problem is that while a date range is selected with the slicer, for some ID's a date is selected which falls out of this range. As seen in my previous post, a date is shown from 2015. This is not correct, and the average is miscalculated because of that.

 

Is this more clear?

 

Kind regards.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (817)