Forum Discussion
Repeat 24 hours average for each day
Hi all, First post here. I’ve gathered the forum and part of Google. I've found similar topics, but I cannot make it work, I’d be grateful for your help. I have an hourly time series in Power B...
Anonymous Soooorry, a huge mistake!!
The correct formula:
= CALCULATE(AVERAGE(Prod_ES[Price]), ALLEXCEPT(Prod_ES,Prod_ES[date].[Date]))the first one took into account only the day, but you have a lot of years and months!BF
Hi BeaBF, I've sent you a Wetransfer link via private message.
Thanks for your help!!!
BeaBF
Super User
Super UserAnonymous Soooorry, a huge mistake!!
The correct formula:
= CALCULATE(AVERAGE(Prod_ES[Price]), ALLEXCEPT(Prod_ES,Prod_ES[date].[Date]))
the first one took into account only the day, but you have a lot of years and months!
BF
IT WORKS!!!
Thank you thank you thank you BeaBF , you're simply the best!!! 🙂