Forum Discussion

mmowrey's avatar
mmowrey
Icon for Helper I rankHelper I
4 years ago

Running total Power BI

I have a running total that stops calulating after 7 days and just inputs the last number continuously..    Here is my formula for running total: Monthly Running Total Goal (RBC) = IF( [Red Ce...
mmowrey's avatar
mmowrey
Icon for Helper I rankHelper I
4 years ago

I have created a dates table and linked as below.. DOes this look correct

 

Whitewater100's avatar
Whitewater100
Icon for Solution Sage rankSolution Sage
4 years ago

Hi:

Yes it looks pretty good. Can your date table also connect to the Donor visit table?

 

Once your date table is made (it should have continuous datesto cover all your time and beyond (for projections) you can go to data view and click on table tools. You should see an option to "Mark as Date Table" say yes and choose you Date field as the field. It will tll you if you did it correctly. Now all the time intel measures will work for you.

 

I hope that helps!

  • mmowrey's avatar
    mmowrey
    Icon for Helper I rankHelper I
    4 years ago

    can i link my date table to both donor visit and blood drive table? maybe thats why this isn't working still .. what table should i link to?