Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
89 | |
86 | |
82 | |
64 | |
49 |
User | Count |
---|---|
125 | |
111 | |
88 | |
69 | |
66 |