Could not calculate Average Progress of the Latest Date in Document

[ruyaselman]

Dear All,

I`m trying to calculate the performance for the latest week (latest entries in my Document).

If you add a manual filter it works in Dashboard, however you have to repeat this every week to capture the latest updates. And it`s not an automated solution.

So I need to create a measure..

I calculated the last day in the Document. And when I want to calculate the AVG Progress and Filter this Date it didnt work.

Latest Date(week) in File -> 23 July 

AVG Task Progress -> 13,75

AVG Task Progress for the latest week(23 July) should be -> 27 ... But I calculated as 13,75

Kindly help..

Latest date formulaAverage progress calculation for latest date

[v-frfei-msft · Accepted solution]

Hi @ruyaselman ,

To create a date table like this and create relationship between tables.

CALENDAR = CALENDARAUTO()

After that, update your formula to have a try.

Progress= CALCULATE(AVERAGE(Sheet1[Task Progress]),LASTDATE(CALENDAR[Date]))

If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

[ruyaselman]

Hi,

I believe I sorted out with the following measure. Just want to share with users who has similar issues;

Progress= CALCULATE(AVERAGE(Sheet1[Task Progress]),LASTDATE(Sheet1[Date]))

Thanks