Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Cumulative Total Based on Custom Weeks

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

 

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    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?