topic Re: Get the average of X last date in DAX Commands and Tips

Get the average of X last date

Anonymous — Fri, 22 Mar 2024 16:29:24 GMT

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 ?

Re: Get the average of X last date

lbendlin — Fri, 22 Mar 2024 21:33:42 GMT

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-Forum/ba-p/963216

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/1447523

Re: Get the average of X last date

ThxAlot — Sat, 23 Mar 2024 06:35:07 GMT

You're close.

Re: Get the average of X last date

Anonymous — Sat, 23 Mar 2024 12:09:02 GMT

Yes. Works perfectly ! Thank you.

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