Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
i have a measure for rolling 12 months, we have daily unit sales - except on weekends. That creates spikes in the rolling 12 months measure (due to weekend shifts from one year to the other). I would like to flatten this, maybe with some sort of rolling 7 days as an intermediate calculation?
Do you have any idea, how i could solve this?
The measure i use for the rolling 12 months looks like this:
Hi @lbendlin
i struggled trying to build/combine these two calculations. Do you have an example calculation on which i could build?
Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
Hi @lbendlin
Sorry for the late response. I can't provide any sample data.
And i can't show the expected outcome because i can't produce it..
But i think i explained it: I would like to flatten the daily spikes of my 12 months rolling line chart.
So maybe it is possible for you to show me a generic calculation on how i could calculated a weekly average and use this for the rolling 12 months (which is calculated on daily basis) ?
"I can't provide any sample data. "
I cannot help you without sample data.
Yes, a sliding window average (let's say three days prior to three days after) should give you the required smoothing.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
79 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |