Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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].
@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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
34 | |
14 | |
12 | |
11 | |
10 |