Cumulative Total Based on Custom Weeks

[Anonymous]

Hi Power Bi Community,

I really need help wrapping my head around this concept. 

I have a set of data that refreshes every 2 hours.

Assume i have the expected sales table below from the sales team for the whole quarter and i would like to measure how much new expected revenue was added into the table to measure their performance,

Todays Data

  

Tomorrow's Data

Expected Measure Result = $55,223 - $48,723 = $6,500

[lbendlin]

Power BI has no memory. You need to do that in the upstream system.  You will need to define what "Today"  and "Yesterday" means. Do you have transaction timestamps?