cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors