Existing aggregate functions are not always useful in a real-time dashboard. Take for example a dashboard that wants to track current speed of a connected car, or current call queue in a call-centre...
Has anyone a workaround to implement showing the latest value of a real-time stream somehow? (We would have a datetime field, we tried to calculate a dateadd(s,-5) column in stream analytics and use AVG in combination with a filter on time to the datadd-Attribute in Power BI but only fixed target values are possible for the filter currently-so this doesnt work at this point of time too)
