Forum Discussion
yuvan29
1 year agoRegular Visitor
Previous 3 day average line graph
Hello, I need some help in creating a measure that caluclates the average value at a certain time for the past 3 days. In my current line graph, I've got different times of the day on the x-axis and...
FreemanZ
Super User
1 year agoHi yuvan29 ,
Supposing you have a data table like this:
you can try to plot a visual with time column and a measure like this:
Rolling 3d Avg =
VAR _date = SELECTEDVALUE(data[date])
VAR _last3d =
TOPN(
3,
FILTER(ALL(data[Date]), data[date]<_date),
data[date]
)
VAR _3dtotal =
CALCULATE(
SUM(data[value]),
_last3d
)
VAR _result = DIVIDE(_3dtotal, COUNTROWS(_last3d))
RETURN _result
it worked like this:
Please find more info in the attached file.
p.s.:
1. If more info could be provided, the code could be further simplified, like in the attachment.
2. With dedicated calendar tables, you will also find Time Intelligence functions like DATESINPERIOD very handy for such cases.