Forum Discussion
Microsoft EmployeeNeed help with creating a measure for streaming data
So I need some help here creating a measure here with a streaming dataset.
The problem is I need to be able to create a measure that will show the amount of money raised today, amount of money raised yesterday and amount of money raised in the last seven days. Though as you can see, each time the data is pushed via the streaming dataset it makes it very hard to do. I've tried setting it as MAX which shows the data correctly though for the maximum amount.
Any suggestions would be greately appreciated here.
7 Replies
v-huizhn-msftHi NWSkier1981,
What your resource table look like? Could you please share your sample table and expected result for further analysis? It's hard to reproduce your scenario without data.
Thanks,
Angelia- NWSkier1981
Sure I can produce additional information here. As you can see the below table has maximum total raised, the date and which campaign they are associated with. Given this is a streaming data set, I had to set the Total Raised to MAXIMUM otherwise it will combine the running total of that column together.
The other graphic shows one attempt, seeing that between yesterday and today the totals changed with a difference of about $52.00
Please let me know if you are needing additional information.
Thanks!
- Ashish_Mathur
Super User
- NWSkier1981
Aww okay like out of an Excel format I take it?
- v-huizhn-msft
Hi NWSkier1981,
Yeah, you can share the sample table in table, excel or csv file(upload the file in Onedrive and share link here). Do hide the sensitive data before uploading.
Best Regards,
Angelia
