topic Re: Average for N measures of date type in DAX Commands and Tips

Average for N measures of date type

Anonymous — Fri, 21 Oct 2022 17:35:43 GMT

Hi everyone , I have the folowing table:

A+1 to A-4 are dates when some client (first column) bought my product. I want to calculate the average of days between every buy (EG: Considering A+1 to A-2 Maria bought every 20 days in average) . A+1 to A-4 are measures.

How can i do that avoiding doing INT([A-1] - [A]) with every "A".

Thks.

Re: Average for N measures of date type

Greg_Deckler — Fri, 21 Oct 2022 17:43:51 GMT

Anonymous In Power Query, unpivot your A columns.

Re: Average for N measures of date type

tamerj1 — Fri, 21 Oct 2022 18:10:07 GMT

Hi Anonymous

do you have fixed number of measures? I guess your problem with the blank measures the thing that ruins the average when you divide by the number of measures?

Re: Average for N measures of date type

Anonymous — Fri, 21 Oct 2022 18:26:55 GMT

ty for your reply, i think i solved the problem creating a new table with sumarize. In that table i used Min(Date) , Max(Date) then in other column i counted distincts dates and that allowed me to get my average by client.

Re: Average for N measures of date type

Anonymous — Fri, 21 Oct 2022 18:26:00 GMT

ty for your reply, i thing i solved the problem creating a new table with sumarize. In that table i used Min(Date) , Max(Date) then in other column i counted distincts dates and that allowed me to get my average by client.