Get the average of X last date

[QuentinBl]

Hello everyone, 

I stuck with a DAX query which doesn't seems impossible. 

I try to get the average for the 5 last date available by client. 
In the following exemple, I want average of the last 5 days available by Client 

In the exemple, Client 1 got 6 days. The last 5 are from 9/03/2024 to 20/03/2024. I want the average of those days

I end up with this DAX query wich absolutly doesn't work 🙂 : 

AVERAGEX(

    WINDOW(

        -4,REL, 0,REL,

        SUMMARIZE(ALLSELECTED('Table'), 'Table'[Date], 'Table'[Client]),

        ORDERBY('Table'[Date],ASC),

        ,PARTITIONBY('Table'[Client])

    ),

    CALCULATE(SUM('Table'[Valeur]))

)

I need the last date value for my client scope

Can you help me ?

[ThxAlot · Accepted solution]

You're close.

[QuentinBl]

Yes. Works perfectly ! Thank you. 

I will analyse why I need a keepfilters here...

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...