Need help with creating a measure for streaming data

[NWSkier1981]

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. 

[Ashish_Mathur]

Hi @NWSkier1981,

Share a dataset and show the expected result.

[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

[NWSkier1981]

Sure thing, please see the link below

Sample HOTS Data

[Ashish_Mathur]

Hi @NWSkier1981,

With respect to the data that you have shared, please show the expected result.

[v-huizhn-msft]

Hi @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!