Forum Discussion
Solved
Plotting a Time Weighted Average for a Period
Hi! I'm very new to PowerBI. I have a table of sensor data that is logged over time (voltages, currents, temperatures). I would like to look at average values for a given time period (day, month, ...
Hi Graham99,
How to get the Time Weight component? By daily average or daily sum? By hourly sum or hourly average? Please share a sample and the result you want. The pbix file would be great.
If you want to sum them up by day then apply the average. you can try it like this:
Measure = AVERAGEX ( SUMMARIZE ( Sales, 'Calender'[Date], "perDay", SUM ( Sales[Quantity] ) ), [perDay] )Best Regards!
Dale
v-jiascu-msft
Microsoft Employee
Microsoft EmployeeHi Graham99,
How to get the Time Weight component? By daily average or daily sum? By hourly sum or hourly average? Please share a sample and the result you want. The pbix file would be great.
If you want to sum them up by day then apply the average. you can try it like this:
Measure =
AVERAGEX (
SUMMARIZE ( Sales, 'Calender'[Date], "perDay", SUM ( Sales[Quantity] ) ),
[perDay]
)Best Regards!
Dale