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?

 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

mmowrey , what else you have in the table other than the day of the week, to create an incremental id like date


Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

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

    can i attach a pbix..

     

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

    thats all i have .. In my date table i have day of week and in my goal table i have day of week..  my running total works until i add an 8th day.. then i keeps whatever the value for the 7th day and just keeps adding it along