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...
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

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