Forum Discussion
Grouping values by date from Push Dataset
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.
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
1 Reply
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