cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

## Per Day Average of Measure.

I have a measure that I would like to get Per Day average. I want to see how many conversions (my measure is [CAPPT]) happen over a given period of time on average.

It would be nice to create separate measures that are rolling X (7, 14, ect.) day averages. I'd also be nice to have a measure that interacts with the date slider I have, so at any given period I am looking at, I can see what the average per day of this measure is. I have a calendar look up, but the issue I am having is I have to have future dates on this calendar (to account for future appointments). This calendar is set 40 days in the future, so using code like MAX doesn't seem to work for me.

Can someone help me? I have LU_Calendar[Date] and [CAPPT].

2 REPLIES 2
Helper II

@FreemanZ Thank you for the response.

Here is some extra data to help with the issue:

I have a measure that uses COUNTROWS to find how many appointments I have:

GAppointments = CALCULATE(COUNTROWS(2023),2023[source] = "g",2023[medium] = "cpc",2023[Appointment] = "Appointment")

I want to count this on a rolling average (or just last 7 days from yesterday).

 8/24/23 5 8/23/23 4 8/22/23 2 8/21/23 6 8/20/23 7 8/19/23 2 8/18/23 10

I want to take this data and just get an average. In this case it would be 5.4 (36/7). I want this to roll and always be yesterday-7 or whatever.

In normal terms, I just want to be able to see how many appointments were generated, on average, the past 7 days. I have a date calendar (Calendar[Date]) that has the date from this year (1/1/23) through 60 days in the future (10/24/23).

If more data is needed let me know. It's just a little bit of sensitive data so I'd have to parse it quite a bit to share and was hoping to avoid that.

Thank you!

EDIT: The table seems to be messed up and I am unsure why it removed the extra column.

Super User

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.