Grouping values by date from Push Dataset

[Anonymous]

Hi! I have a Push Dataset that has IoT Sensor data. I'd like to create a table that has average values for each day. The problem is that I get about 100 values per day and I don't know how to group them. I can't create a calculated column, because the data is a push dataset. I included a photo of the situation I'm at this moment.

[Anonymous · Accepted solution]

Hi @Anonymous ,

As you said, you are working with push datasource on power bi service and it not allow you to create calculated fields.

I'd like to suggest you add a category fields in datasource side, you can use rest api to push new data structure records to power bi side and design report based on category fields.

Regards,

Xiaoxin Sheng