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

In the table i am pulling from, there is no date.. Its just a day of week (1-7). I created a new measure (day of week) and linked those tables.  

 

I fixed my formula as you suggested but did not fix issue.. Is it my date?

 

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

Hi:

Once you get your date table connected to your fact table with the donanation info and marked as a Date Table you can use functions like this for your monthly totals or beyond. Below the date table is named DATES. You can also use DATESYTD, DATESQTD

Month RT= CALCULATE ( 
   [Red Cell Projected]), DATESMTD (Dates[Date])
)

 

  • 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?